Report Grouping

[isorders]

I think I am approaching this the wrong way, but I can't figure out how to get all of the records of a grouped item to appear together without using a subreport. I am trying to create a report for a feeding schedule.
Ex. Report
Group Header:AnimalID
Group Header:Hay
Group Header:Grain
Group Header:Supplement
There can be many or no Hay, Grain and Supplement records for each Feeding. All are linked by FeedID, tblFeed, tblHayDetail, tblGrainDetail, tblSuppDetail. The query is set to pull all records from tblFeed and only those records from the others were equal.

I want the Animal Details to appear at the top of the report and then the Hay, Grain and Supplement records.
What I want the report to do is:
FeedID, Feed Details, etc
Hay1
Hay2
Hay3
Grain1
Grain2
etc.

Right now it appears
FeedID, Feed Details, etc
Hay1
Grain1
Supplement1
Hay2
Grain2
Supplement2
etc.
Any help would be great.
Thanks

 

[RiverGuy]

I think you would have to use sub-reports. This is because Access sees your query basically as a table. And the records are linked by ID's, so each related record forms one record.

 

[CosmoKramer]

I agree - done correctly, the subreports would appear like one physical report. Just remember the Can Grow and Can Shrink properties.....

 

[isorders]

Thanks for the quick response, I had a feeling that was going to be the answer.