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