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

Figured it out!
When you put an iif statement into criterea, in the query menu it appends an "Table.Field =" prior to the iif in the SQL
so the where statement if the iif evaluated true ended up being
Table.Field = >0 which doesn't make much sense

So I used your idea Lee and if you put this in the Value Section
and then put <> False as Criterea, you get the correct recordset.

Thanks for your help

Reply With Quote