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

M

Melani

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
 
R

Rick B

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
 
R

Rick Brandt

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