2 Crosstab query report

  • Thread starter Thread starter Photios_Kim
  • Start date Start date
P

Photios_Kim

I am trying to build a database for Trouble ticket tracking.
I run two crosstab queries for Open ticket status and Closed ticket
status. Open ticket query run by OpenDate and Closed query run by
ClosedDate. Both queries are summary query by monthly. I am trying
to generate a report that shows information from both queries. Is
there anybody who know how to do this? When I combine two queries, it
generates catarcian products.

Thank you,
 
The quickest thing that occurs to me is to generate two subreports, one for
each of your crosstab queries, and put them into a single report.

If your cross-tabs don't show the same fields (due to no data), you could
include an IN clause for the PIVOT to force them both to have the same
fields.

HTH,

Rob
 
Presumably there is a common ID field in both queries?
If so, when you add both the queries to the new query, ensure there is a
link between the ID fields (in the top part of the design view window,
drag one ID field on top of the other).

Regards,
Andreas
 
Back
Top