Criteria froma form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an expression in a queryas followsStaleflag:
IIf([DealMaster]![TransStatus]=1 Or
[DealMaster]![TransStatus]=2,IIf(Now()-[DealMaster]![DateLastUpdated]>16,"Stale","Current"),"Current")

This works fine returning either a status of "Stale or "Current". In the
criteria, I have a reference to a form checkbox as follows:
IIf([Forms]![Criteria]![StaleCheck]=-1,<>"stale")

This where i'm hung up. What I an to happens is if the check box is
checked, filter out all "stale" records. If it is unchecked, apply no filter
at all to the records. Right not, it's returning no records in either
position.
 
Back
Top