Using MS Access expression builder for if fieldA value = " then fieldBdate = " table name is myOrder; myOrder has several fields including fieldA text (using value list for value selection, of which "Received" is one); And another field is named fieldBdate of DateTime type.
either
iif (fieldA] = "Received",[ fieldBDate] = Date(), null);
or
if ([fieldA] = "Received" then[ fieldBdate] = Date()
failed to meet with Access expression syntax
with both Access 2000 and Access 2010. What's the correct syntax?
Thanks.