Access Question about Reports

[Jen]

Hello. I am trying to combine three queries onto one report - one query is
on the left, one is on the top right, and one is on the bottom right - and I
am having a problem combining the data from all three. There is a common
field which I have grouped the data by and which is common in all three
queries, let's call it the "Baseball Teams" field. I want the baseball team
headings from the left query to line up with the same baseball team heading
from the top right query in addition to adding the information for the same
baseball team heading from the bottom right query directly below each
baseball team heading from the top right query. An illustration might be
easier...The left query contains the Yankees with five records below it, the
Pirates with two records directly below it, followed by the info for the
other teams. At the same time, the top right query will show the Yankees
records directly in line with the Yankees info on the left and then the
bottom left query Yankee information followed by the Pirate information from
the query on the top right query and below it the data from the bottom right
query.

I hope you can comprehend my question! Any advice is greatly appreciated!

 

[KARL DEWEY]

Build a union query that has the "Baseball Teams" field from all three. Use
the union query and left join to each of the other queries in a fifth query.
In the report posistion textboxes for the data from each data type you want.
Set Hide Duplicates to Yes and set Can Grow and Can Shrink to Yes.