Reports/Subs with comparitive data

[bulldawgfan12000]

Hi,
Access 2003: Sorry for the long post....Couldn't find any posts that
solved my problem with reporting on a big query. If anybody can help,
I'd REALLY!!! appreciate it. I have a query that, paraphrased,
results like this (there's duplicate data in the KEYFIELDs which is my
problem):

UserID___Field1a___KEYFIELD1___Field1b___KEYFIELD2
user1---------abc-------------KEY1--------------ghi----------KEY6----
user1---------abc-------------KEY1--------------ghi----------KEY7----
user1---------abc-------------KEY1--------------ghi----------KEY8----
user1---------hbc-------------KEY2--------------ghi----------KEY6----
user1---------hbc-------------KEY2--------------ghi----------KEY7----
user1---------hbc-------------KEY2--------------ghi----------KEY8----

user2---------abc-------------KEY1--------------ghi----------KEY6----
user2---------abc-------------KEY1--------------gki----------KEY7----
user2---------abc-------------KEY2--------------ghi-----------KEY6----
user2---------abc-------------KEY2--------------gki----------KEY7----

(Field1a relates to KEYFIELD1. Field1b relates to KEYFIELD2.)

I would like the result of my query to, basically, look like this:

----------------------------------------------------------------
user1 KEY1 abc KEY6 ghi
KEY2 hbc KEY7 ghi
KEY8 ghi
----------------------------------------------------------------
user2 KEY1 abc KEY6 ghi
KEY2 abc KEY7 gki
-----------------------------------------------------------------


Alternatively, I could have the report look like this
----------------------------------------------------------------
user1 KEY1 abc
KEY2 hbc

KEY6 ghi
KEY7 ghi
KEY8 ghi
----------------------------------------------------------------
user2.....(same format)
......
...

Trying to solve the problem, I have created 2 queries which use the
above query as the source. In those 2 queries I can "Group By" and
isolate on KEYFIELD1 and KEYFIELD2 which solves the problem with
duplicates. But, I don't know how to include them both Side By Side
on a Report (via subforms?) the way I illustrated above.

Can anyone point me to a thread or somewhere that explains how to
create a report like this?

Thank you all very much...

 

[bulldawgfan12000]

I was able to figure this out....finally. Of course, I didn't have my
relationships right. What made it difficult to troubleshoot was that
the report was so slow in opening i couldnt easily see what it was
doing wrong. Regards.