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