how do I write "if" criteria?

[Jaron]

Hi,


can anyone tell me how to say the following:

if [field1] equals "no", don't show anything, except if [field2] says "yes", in which case show it anyway.

[rzw0wr]

try,
Iif([field1]="NO" AND [Field2] = "YES", field1.visible=true,field1.visible=false)

Dale

[Jaron]

In the query, in design view, do I write this in the criteria for field 1 or 2?

[rzw0wr]

What I gave you won't work. Sorry.

In field1 type ="NO" - in field2, on the SAME line type ="Yes"
Make sure the field1 is before field2 in the query.

Inputting criteria on the same line = an AND. Criteria not on the same line = an OR.


Dale

[Jaron]

Excellent! Thank you!