modification date query

eggwater

life as a rehearsal
Local time
Today, 13:08
Joined
Aug 14, 2003
Messages
69
I'm trying to design a query that uses a Boolean expression to create a calculated field that looks at a field to find whether the looked up field = 1 OR 2

I'm not sure on the syntax see below and help me with the parentheses etc:

Newfield: IF([Accom_record_card]![Export_ctrl] = 1 OR 2 THEN Newfield = date() etc....
 
You need this format: IIf(condition,do this if condition is true,do this if condition is false)
 
To be a little more specific:

Newfield: IIF([Accom_record_card]![Export_ctrl] = 1 OR [Accom_record_card]![Export_ctrl] = 2, date(), ?????)

You need to supply a value for when the condition is false. If you want the date to be null, just replace the question marks with the word NULL, no quotes.
 

Users who are viewing this thread

Back
Top Bottom