Create a query that will allow users to enter data in Access

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

Guest

I set up a table in Access showing "city, client number, name and balance".
Now I am trying to set up a query that will allow the users to enter the city
they want and then the selected data for that specific city will appear. In
the help box it said to go to Design view and in the required box type yes. I
did that and then saved it and tried to set up a query again, it didn't work.
Is there something else I should be doing? Thanks.
 
Dear Tracy:

What you want probably looks, in part, like this:

WHERE city = [Enter City name: ]

If you post the query you have that doesn't yet have this feature, but
whatever else you need, someone will probably be able to give you more
specific help.

Tom Ellison
 

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

Back
Top