IIF Statement

golden · July 9th, 2004, 12:41 PM

I have a text box on a report called Procedure that has a record source of Procedure.

I am trying to make the record source be:

=iif([Category]="Glasses",[Procedure],"0")

instead of displaying the "0", what I really want is to skip the 0s and go to next. Any idea how to do that?

Thank you.

Regards

Loke

dhay1999 · August 2nd, 2004, 01:51 PM

=iif([Category]="Glasses",[Procedure],"") will produce a blank

I'm not sure what you mean by go to next, next record or next category?

Steven · August 3rd, 2004, 01:32 AM

why don't you have, in the SQL that is the recordsource, something like:

Code:

SELECT YourField1, YourField2, IIF([Category]='Glasses',[Procedure],Null) 
FROM YourTable
WHERE Category='Glasses'

I am a loud man with a very large hat. This means I am in charge