report one row with list for one record

[highwayman]

I have two tables that look like this:

Table 1
Session Group Trainer
A 1 John Doe
A 2 John Doe
B 1 Jane Doe
B 1 Jane Doe

Table 2
Session Group Trainee
A 1 John Smith
A 1 Jane Smith
A 1 Robert Jones
A 2 Sally Jones
A 2 Steven Williams
A 2 Rebecca Williams
(and then entries beyond this, you get the picture)

I'd like a report that looks like what is shown in the attachment. Note that the sample attachment was made in Excel, but I am in fact working in Access.

Not sure what I need to do in the query/report to generate this output.

Thanks in advance for the help!!

 

[Alansidman]

This is close but not exact

SELECT Table1.Session, Table1.Group, Table1.Trainer, Table2.Trainee
FROM Table1 INNER JOIN Table2 ON (Table1.Group = Table2.Group) AND (Table1.Session = Table2.Session);

Once you have your query, then you filter in a report using this tutorial as a guide.

http://www.datapigtechnologies.com/flashfiles/groupinginaccessrpts.html