Parameter Query - Every Date or One 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
 
D

Douglas J. Steele

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.
 
Top