How to create an input field in query

[Guest]

If I had a query that pulled from several tables and one of the fields pulled
was State. How can I get the query to ask me what state I want..so I can type
in NY or MN or CA and have it just give me those?

Thanks

 

[Guest]

One simple way is to do so in the design grid of the query. You could simply
type the following into the first 'Criteria' row under the State field:

[Enter the State you want]

Or, whatever you want it to ask for. When the query is triggered, a box
will appear, asking the user for the input. Be sure to include the brackets
as shown above.

In the Access Help files you can look for 'Parameter Query' to find more
information.

 

[John W. Vinson]

If I had a query that pulled from several tables and one of the fields pulled
was State. How can I get the query to ask me what state I want..so I can type
in NY or MN or CA and have it just give me those?

Thanks

On the Criteria line underneath the state field in the query grid type

[Enter State:]


John W. Vinson [MVP]