Report Grouping HELP!

[freebd99]

I have four tables:

Participants (partID)
Core Details (coreID)
Elective Details (electID)
Registration (regID)

I have some test data for a couple of people and I want to create a report that pull all info from these tables, whether or not they are doing one or six days of training to create something like a student schedule report. But when I do a query it display multiple rows. So for example the query will look like

PartID RegID CoreID ElectID
1 2 3/5/03 4/5/03
1 2 3/6/03 4/5/03
1 2 3/7/03 4/5/03
1 2 3/7/03 4/6/03

Etc. It's not grouping everything under one RegID so that in a report I can create a template that will put together all that information.

Participant and Registration are linked by PartID, Core Details and Elective Details are linked by the RegTranID.

Thanks in advance for any help/suggestions.

 

[AlexMidd]

A bit confused by your layout. You have CoreID and Elective ID as dates - is this right?

Basically, if you want to group by, say, RegID, you must set this up in the "Grouping and Sorting" area and change the "Group header" line for this to "yes". You then put the control for the RegID data in the Group Header, and anything that can have several rows within the Group into the "Detail" section. Then all Core and Elective details for RegID 2 would be listed under the RegID which would appear once.

Not sure if this is what you need, but I hope it helps. Have fun! )

Alex Middleton