Group Subtotals

[Blorf]

Hi.

I have two tables, one called group, another called details.

I link then to run a report. Using Group as my group header and Details is rows.

Within Details, there is a cost for each line. There may also be a cost in the Grouping record.

I need to add the cost for the group, to the sum of the cost for the lines at end of each group, and again at report end.

Doing this I get the group cost each time there is a line, so it doesn't work.

Probably there is a way within the report, but if not, I will have to use a report sub report style option.

Any advice would be appreciated.

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[Blorf]

Design Flaw. Fixed. Disregard.

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.