variable criteria

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

Guest

I use a query in a subform. I then put a checkbox on the main form that when
checked is supposed to return data for todays date. If not checked, return
all. I have an IIF(checkbox, Date(), <=date()) stmnt in the criteria field
of the query date field. But no matter if the checkbox is checked or not, no
records are returneed.
I tried a Requery with no help. Waht am I not doing.

Mike
 

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

Changing query criteria 1
Checkboxes Option Group Questions 1
Checkboxes and Query Criteria 1
Using IN() with IIF in criteria 3
question driven query 6
Using 'Not Equal' in a Totals Query 3
How to Filter on Multiple Fields 5
Using IN() with IIF in criteria 2

Back
Top