show all records

S

smokie

If I do not take out my criteria in my query i cant view all my records. And
what can i do to clear the criterai automatically after i have run the query
 
R

Rick B

What is your query? What criteria?

If you allow the user to enter the criteria when running the query, then you
can sometimes enter it to get a restricted list, and other times leave it
blank to pull all records.

Share your SQL statement and we can give you more details.


smokie said:
If I do not take out my criteria in my query i cant view all my records. And
what can i do to clear the criterai automatically after i have run the
Click to expand...
query
 
S

smokie

Rick
All the critiera is a date or "yes" field. If I try to print out a report
and they are not selected in this critiera I won't get those records. Its
just a simple query
 
R

Rick B

The statement, "All the critiera is a date or "yes" field" makes no sense.

Please post the SQL of your query so we can see what you are pulling.
 
Top