Parameter Query - Every Date or One date

  • Thread starter Thread starter CHARLES.CLAYTON
  • Start date Start date
C

CHARLES.CLAYTON

A2K

I have a query where I enter a parameter to show all records for that
date (which is what is entered at the prompt). Sometimes, however I
want to see all records regardless of date. How do I set that up in
the query builder window?

Thanks,

Charles D Clayton Jr
 
Assuming your query is something like "WHERE MyDate = [Pick a date]", change
it to "WHERE MyDate = [Pick a date] OR [Pick a date] IS NULL"

Just hit Enter when prompted, and you should get everything.
 
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

Query Parameter using multiple options 0
Parameter Query to Find Records <= 3 yrs Prior to Entered Date 4
Query date Parameter Anomaly 4
Date search query 0
Report Query Parameters 2
Using Date parameters in select queries Access 2003 5
Parameter Query 2
Carry over date from previous record 1

Back
Top