Still in a VERY steep learning curve with MS Access 2000 / 2003
Main Table has LastName - HomePhome - MobilePhone plus others of course
Some rows will have no entry in the HomePhone field but will have one in the MobilePhone field.
I am trying to set Query criteria to give me "If HomePhone is Null (no entry) then insert the data from the MobilePhone field into the HomePhone query result"
Have tried the IIf statements, but to no avail. Am fast losing what little hair I have left!
Please can anyone help ?