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)