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.
 
Try this in the filter
<> IIf([Forms]![Criteria]![StaleCheck]=-1,"stale","aaaaa")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

iif in the criteria 3
Query Criteria Not Working 2
no criteria 3
Dynamic Query Criteria 5
Criteria to return all records if selection from form is null 3
Help with IIF in Criteria 1
Problem with Criteria 12
Filter query using checkbox and IIf function 2

Back
Top