show all records

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

Guest

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