Nested IFs

[mlocurci]

I need to nest IFs and I don't know how to do that. I need to check one field for a value and look at another field for a value. If field 1=x and field 2=y, I want to count that.

Ideas?

Thanks!

 

[luceze]

Try this in the field of your query:
IIf([x]=1,IIf([y]=1,([x]),0))
and set the totals field to count

 

[mlocurci]

Its supposed to be in the a report though

 

[Nancy2]

Use the above statement as the control source of a text box in your report

 

[luceze]

Okay. Try this in a text box in your report.

=Count(IIf([Field1]=x,IIf([Field2]=y,([Field1]),0)))

where field 1 and field 2 are the names of your fields, and x and y are the criteria.

Eric