Multiple Crosstab Queries in a Report

[rplant]

I used the search feature and couldn't find any related posts.

I'm trying to create a report which combines 2 crosstab queries. The crosstab queries are similar in layout and the data presented.

This is what the queries look like:

Facility Date1, Date2...

Building One Taxes Taxes
Building Two Taxes Taxes



The only difference is between the 2 queries is that they pull data about different cities.

I want to create a report which allows me to put both of these queries into one report entitled: Taxes by Facility for all Cities. I hope this was clear. TIA.

Rob

 

[nberryman]

Base the Report on one of the queries and ammend it to

="City1" OR "City2"

This should do the trick

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com