See all data from a parameter query

R

Rod

I would like to sometimes run a parameter query but see all of the data and
not just certain criteria. Is there a way to do this?
 
F

fredg

I would like to sometimes run a parameter query but see all of the data and
not just certain criteria. Is there a way to do this?
Click to expand...

Several ways, depending upon what you are using as criteria.
As an example:

WHERE YourTable.YourField Like [Enter Criteria] & "*" OR [Enter
Criteria] Is Null

or...
WHERE YourTable.YourField = [Enter Criteria] OR [Enter Criteria] Is
Null

etc.
 
Top