eggwater
life as a rehearsal
- Local time
- Today, 09:30
- 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....
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....