Thread: IIF Statement
View Single Post
  #1 (permalink)  
Old July 9th, 2004, 12:41 PM
golden golden is offline
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default IIF Statement

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