Each of my lines in the underlying query for my report are grouped, on the report, by Item Number. This is just a consecutive count for each item on a Sales Order (this can't be changed as it draws its information from Sage).

I want to separate the "Carriage" line which, for very good reasons, is a product item. In the query I've used expressions to separate product items and carriage lines into separate fields.

Ideally I would like to show the carriage line in a separate footer but if I put it in the Order Number footer then it will show up but I can't make Access perform a running total. I need a running total in order to create a Grand Total in the page footer by adding the running total of the items and a running total of the carriage together. If I put it in the detail of the report then it shows as a separate line under each of the other product items of course.

Could anyone suggest a way to do this please?

Thanks

Would a subreport work?

Thanks Rich

Tried it briefly just to see what would happen.

Looks good so far. I've always steered away from subreports as they seem to make things more complicated...but I guess it's time to get past the phobia! Thanks