Group by ID

[silver]

Guys i have 3 queries im using to list users satisfying certain conditions and would like to print this off using a report. Since i have the same companyID's in the results of the 3 queries how do i group them according to their IDs? At the moment the report first prints ALL records from Query1 then records from Query2 then Query3 but instead i want to print FIRST record from Query1 FIRST record from Query2 then FIRST record from Query3....and so on.

im having

ALL Query1
ALL Query2
ALL Query3


but i want....

record#1 Query1
record#1 Query2
record#1 Query3
****pagebreak*****
record#2 Query1
record#2 Query2
record#2 Query3
****pagebreak*****
record#3 Query1
record#3 Query2
record#3 Query3

i already know that the record IDs from the results of each query are the same.

please help!!!

 

[pbaldy]

In Sorting and Grouping, have you told it to sort by that ID field?