modification date query

[eggwater]

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....

 

[Tiro Cupidus]

You need this format: IIf(condition,do this if condition is true,do this if condition is false)

 

[Pat Hartman]

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.