Troubleshooting Select Queries for Report

[devdar999]

I have a report based on a Crosstab query. Report prints cities with
lists of certain businesses in each city. I'm trying to customize my
report so that it only prints cities that contain the name of the
business I want. For example:

City 1
McDonalds
Burger King
Wendys

City 2
Wendys
Arbys
Subway

City 3
Pizza Hut
Arbys
Joes Deli

If I enter "Wendys" I'd want it to print ALL of the businesses in City
1 and City 2. (Wendy's is not in City 3 so it wouldn't print that.) If
I put "Wendys" as a criteria under 'biz name' then it'll just print

City 1
Wendys

City 2
Wendys

I want all businesses listed for just those 2 cities. I don't know if
my criteria should be at the query level or at report level. I'm not a
VBA whiz so don't want to do involved coding.

Thanks!

 

[Guest]

Create a new query with the "cities" and "business" tables and put Wendys in
the criteria.

Save the query. Add this query to your report record source query and join
by city name (or city ID if one exists).

This will limit the returned records to only cities that meet the newly
created query's criteria.

HTH

Terry

 

[devdar999]

Worked great, thanks a lot.