Selecting Criteria in Queries

  • Thread starter Thread starter Stephen Brown
  • Start date Start date
S

Stephen Brown

I'm used to entering simple criteria when running a query
such as a date range and I want to be able to have users
select a name at the time they run the query, but I want
them to select the name from a "drop down list" of names
contained within an existing table. How can I do this?
 
Use controls on forms to provide the criteria for the query. You can't use a
drop down in a parameter query.
 
You must log in or register to reply here.

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
Access Access Query Criterion 1
show criteria data from a query on a report using that query 2
Access Dcount (multiple criteria) 3
Query Criteria issue 5
Criteria in a Querie 8
How do you modify / negate criteria based on a form 1
Criteria for select query. 2

Back
Top