Multiple-query report help

[pareez]

I'm trying to create a report from three queries. The only problem I'm
having though is the report is showing all the data from the first query,
then all the data from the second query and then all the data from the third
query in the report. I want the report to show the first record from the
first query, then show the first record from the second query and then show
the first record from the third query and so forth. The reason I want the
report to show like this is because all three queries are related to each
other and compliment each record in each query. All three queries share a
common field and can be linked together.

 

[Larry Linson]

I'm trying to create a report from three queries. The only problem I'm
having though is the report is showing all the data from the first query,
then all the data from the second query and then all the data from the
third
query in the report. I want the report to show the first record from the
first query, then show the first record from the second query and then
show
the first record from the third query and so forth. The reason I want the
report to show like this is because all three queries are related to each
other and compliment each record in each query. All three queries share a
common field and can be linked together.

My guess from what you describe is that you need to create a new Query,
joining the existing ones, to make one Record from the three... then put
Controls in the Detail Section to display the data that originally came from
the three related Records.

In the QueryBuilder, choose the Query that is least likely to be missing any
Records, and join the other two Queries to it on the common Field. Click the
join line to highlight it, then right click and choose "Join Properties".
Then use the "All records from .... and only those that match" -- that way,
a missing Record in one Query won't cause you not to see the two that do
exist.

Larry Linson
Microsoft Access MVP