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 not a valid name - error in Access.
My query functoin is:
If my [OffenderID] field = 0000000000000 and the [ForeignID] field is not Null, then the [OffenderID] must be populated with the value in the [ForeignID] field. If the [ForeignID] is Null, then the data in the [OffenderID] field must remain as is.
What am I missing please?
January 3, 2012 6:14 AM
February 28, 2012 12:45 PM