View Single Post
  #4 (permalink)  
Old December 8th, 2005, 11:36 AM
Enoch Enoch is offline
Authorized User
 
Join Date: Dec 2005
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Leehambly, thank you for your advice, however I am still having a problem with the iif statement.
I put the original iif statement into the value rather than criterea field except with quotes around the >0 (so it would work). The logic appears to work correctly.
So then I thought, perhaps in the criterea it's trying to literally match >0 to the ID field rather than numbers greater than 0. Maybe I need quotes or something, but when I put quotes around >0 in the criterea section, it gives an error that the expression is too complex.
I know you can nest iif statements but it seems like you can't put any other expressions into the (case if true, case if false) sections of a query. (I'm probably wrong)
Additional help would be appreciated.
Thanks

Enoch
Reply With Quote