CrossTab Queries (1 Viewer)

[Jade]

Good Day,

I was wondering if anyone could tell me if there is anyway to have two columns in a crosstab queries? I have two fields from two tables that need to be in columns in the query, but it doesn't allow me to do that. If I make two crosstab queries and make another query so I have those headings for a report, it triples the data.

Any suggestions?

Thanks,
Jen

 

[Pat Hartman]

You need to make two crosstab queries (one for each column) and the row headings need to be identical for both queries. Then the third query joins the two crosstabs on ALL the row heading fields.