Grouping in Report

[Leelers]

I have a table of data for subjects in a research study. There have been 5 rounds of data collection, so every subject has 5 rounds of data (phone numbers, etc). I need to generate a report that shows the subjects name and ID number, and then every phone number that has been recorded for them in every wave. But so far all I can manage to do is generate lengthy and repetitive reports in which I get the subject's name, ID, phone numbers in five separate groups.

So my data looks like this:
ID Name Phone
1 Smith 3334445555
1 Smith 3334445555
1 Smith 3334447777
2 Jones 3334445556
2 Jones 3334448888

And I need a report that says:

ID: 1
Name: Smith
Phone: 3334445555
3334447777

ID: 2
Name: Jones
Phone: 3334445556
3334448888


But instead I can only generate reports that look like this:

Id: 1
Name: Smith
Phone: 3334445555

Id: 1
Name: Smith
Phone: 3334445555

Id: 1
Name: Smith
Phone: 3334447777

And so on. Little help? I'm in Access 2003, btw.

 

[KenHigg]

You should be able to do this with the report sorting and grouping feature - ?

 

[Leelers]

Can you help me more specifically with that? I'm sort of a noob to access.

 

[KenHigg]

In the report design view do a right click and you should see the 'Sorting & Grouping' option...

 

[Leelers]

It's still not helping me. I still get a bunch of entries by wave for each subject. I want all of the phone number data from each wave in a single group for each subject, rather than multiple groups for each in wave. Am I missing some trick in the sorting/grouping function?

 

[KenHigg]

You have to set the group header option to yes for the appropriate field.

 

[Leelers]

Ok, I don't think the sorting/grouping option can help me here.
I want this:
ID: 1
Name: Smith
Phone: 444444444
55555555

I am getting this:
ID:1
Wave: 1
Name: Smith
Phone: 4444444

ID: 1
Wave: 2
Name: Smith
Phone: 5555555

 

[stopher]

I agree with Ken. Grouping is the answer to this problem. The trick is knowing what fields go where and which groups.

"Phone" needs to go in the detail section.

If you don't want to see "Wave" then remove it from the report altogether (including the Wave group if you have one).

Stick with it... you'll get there.

Chris