Multiple input criteria in a query

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

Guest

I have a query that I am trying to pull all the records from a state field
based on user input. I know using [] can get me one state but if I try
entering data such as "fl","GA" it comes up blank. I have also tried
In([Enter State]) thinking that would do it, but nothing.

Any help would be appreciated.
 
For the user input, I would make a subform, which is based on a table. (use
a combo box on subform if you like)

In the query, link the subform table in the query(to whatever other table)
to extract only those states that the user selected.
 
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

Access Dcount (multiple criteria) 3
State abbreviation MI fails in query 2
Criteria in a Querie 8
Using Forms for Query Criteria 1
Parameter Query Won't Run 0
Query Criteria in Access 1
Multiple AND criteria 2
Show user input in message box 3

Back
Top