Please excuse my noobness but I am new to Access and rarely work with it. How do I replace the data in 1 field with the data of another field, if any data exists in the 2nd field? I suspect IIf would be the best way but I get 'NewID: IIf([OffenderID]="0000000000000",[ForeignID],"0000000000000")' is...