Selecting all from query criteria

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

Guest

This is probably an obvious one but I'm blank.
I have a query selecting the data for my report and it requires user input
on running the report ie. [Enter Name] in the criteria for one field of the
query. This works great when I enter a specific name. What I also want to do
at times, is select all the data regardless of which Name it belongs to. I
think I should be able to enter some kind of wild card once I have run the
report but I can't remember!!!
 
Make your criteria prompt read like this --
Like [Enter Name] & "*"
Just pressing the ENTER key on promt will return all records.
The above require entering the start of the name. Below requires only a
part of the name.
Like "*" & [Enter Name] & "*"
 

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

Use In() Expression as Query criteria with guts from Function 1
Passing criteria to queries from forms 2
show criteria data from a query on a report using that query 2
Criteria for select query. 2
Criteria in a Querie 8
Query with Multiple Criteria 4
2 independent criteria 1
Access Access Report Works on One Machine but not Another 3

Back
Top