I need to create a make-table query that changes the value of a field titled Barcode depending upon the value stored within SP_DEFAULT_SA_EXP_END_DATE, which is a Date/Time field.
The expression I have entered into the criteria of the Barcode field is as follows. When run however it causes no data to be entered into any fields at all.
IIf([SP_DEFAULT_SA_EXP_END_DATE] Is Not Null,[SB_REF] & "/" & [SP_REF],[SB_REF])
Can anyone offer any suggestions?