one record multi users

[Dan @BCBS]

I'm trying to create a report to show two things.
One record could have multiple people work it. I need a report to show that
record ID one time but then also list all the Users
Report Example:

MainID UserID
12345 Joe
Sue
Ed
67898 Dan

Main table (Key value = MID, also has a value for UserID)
User table (Key value = UID, also has a value for MainID)

Something like this code below, returns each individual record (multiple
Main MID) I understand why, because that's what it's asking for - but how do
I get to a report showing one record then every user under it.
SELECT t_Main.MID, t_User.UID
FROM t_Main INNER JOIN t_User ON t_Main.MID = t_User.MID;

Any suggestions?

 

[Jeff Boyce]

Put both fields on the report as controls, then change the Show Duplicates
property of the one you don't want to see repeatedly.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dan @BCBS]

Thanks I forgot about that feature...

Put both fields on the report as controls, then change the Show Duplicates
property of the one you don't want to see repeatedly.

Regards

Jeff Boyce
Microsoft Office/Access MVP