Thread: IIF Statement
View Single Post
  #3 (permalink)  
Old August 3rd, 2004, 01:32 AM
Steven Steven is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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