Need Help with Report and Grouping

[rodrunner79]

Hello,

I've been scratching my head as to how I'm going to do this on a report and have been trying different ways but to no avail. So I decided to seek help from a site that never fails. Please bear with me as I try to explain it what I need the best way I can.

Basically, I have a report that returns details at a purchase order line level. The data on the query looks like the attachment--please take a moment to review the data as I will base my inquiry on it.

The current report returns all details on the Detail section. There's nothing wrong with that and I still want it to do that but I also want to add grouping to the report by Room and then by GL_ACCOUNT code with the LINE_AMT aggregated but I want this to show at the end of the report (Report Footer). For example, if you look at lines 1, 2 and 4, they are all for Room #1 and line #3 is room 2. I want the following grouping at the Report Footer:

ROOM 1 - 9999 $15.00
ROOM 1 - 1234 $2.50
ROOM 2 - 9999 $2.50

Note that the data I am reporting is massive so there may be an instance where the grouping can go up to 100 lines. I need the grouping at the report footer to auto grow/shrink if necessary.

Please help.

Can't means won't try.

 

[dhookom]

Create a subreport to display the aggregated data in your report footer. You can use the Link Master/Child to filter the subreport to the same Purchase Order.

BTW: there is an Access Report forum that would be more appropriate for this question .

Duane
Hook'D on Access
MS Access MVP