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
Default

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
IIf([Forms]![frmOutflow]![fsubOutItem]![cboCategory1Select]=1,
([tblItem].[Category1ID])>0,
([tblItem].[Category1ID])=[Forms]![frmOutflow]![fsubOutItem]![cboCategory1Select])
and then put <> False as Criterea, you get the correct recordset.


Thanks for your help


Enoch
Reply With Quote