How do I get a query to prompt me so i can type the information I

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

Guest

Hi,

I have a city column and I would like to be able to type the differenct
cities in a prompt that comes on the screen instead of having to keep
changing it in the query design.

Is this possible?

Thanks

Melani
 
In your criteria to get only cities that match put....

[Enter City]


To get cities that don't match, put...

Not [Enter City]


To allow partial entries put...

Like "*" & [Enter Partial City] & "*"



HTH, Rick B
 
Melani said:
Hi,

I have a city column and I would like to be able to type the differenct
cities in a prompt that comes on the screen instead of having to keep
changing it in the query design.
Click to expand...

In the criteria line of your query under the City field add..

[Enter Desired City]

You will have to enter exact matches into the resulting dialog.

The way this works is that anytime Access see something in a query that it
cannot identify it assumes that it is a parameter and it will ask the user to
provide a value for it.
 
Back
Top