Union query report, parameter prompt? Report filter?

[Lifeseeker]

Hi,

I have an working union query from which a report can be generated. The union query combines two queries, which represent two tables.

One of the features I would like to add for the users is the ability to specify the city name when the report loads.

Right now when the report opens, it shows results from all the cities.

Is there any way to put an parameter prompt window for users to type in a city? Does this have to do with report filter? Or do I have to put an parameter in both of the two underlying queries?

Any thoughts/help much appreciated.

 

[pbaldy]

You can either put a parameter in the query (probably both parts, but depends on your specifics), or use a technique like this:

http://www.baldyweb.com/wherecondition.htm

Personally I'd use a form for user input, but you can use a bracketed criteria in the query.