Multiple input criteria in a query

B

Bob

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.
 
M

[MVP] S.Clark

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