Criteria and IIF

[generaluser]

Can you do an IIF such as:

If [field2] is not null
Then if [field1] = x and [field2] = y then [field 3]=z.
with multiple values for [field2]

without programming? Would you do it in a query?
Please let me know.

 

[GoDawgs]

if this is on a report then something like this in a text box would work I think:

=iif([field2]<>&quot;&quot;,iif([field1=x],iif([field2=y],[field3]=z)))

 

[generaluser]

call me stupid, but I never knew what &quot;<>&quot; meant

 

[generaluser]

also, (I forgot), what if [field1] has multiple values as well

 

[GoDawgs]

You figured it out now? Or you still don't know? If you still don't...<> is not equal to

 

[GoDawgs]

Oh I see...I misunderstood at the beginning, so I'm kinda going the wrong way...