Recent content by 67philb

Hi all, just wanted to say thank you for your replies. It’s really helped me out, I’m not 100% there, but a lot closer than I had been. Thanks again Phil

never thought of a running sum, that might actually work for what I need. Thank you!!

Hi Pat, thanks very much for the reply, and moving my thread (sorry). You are right, normally I wouldn’t have checked the figures on a calculator but knowing it was for a main customer I wanted to make sure all the boxes were ticked. “Have the grand total total the subtotals” how do I go about...

sorry, how do I post on the correct page?

Hi, I’m Phil from the UK I’ve used access on and off over past 20 years wouldn’t say I’m a novice but also not anywhere near an expert!! Never posted on any threads so apologies if I get something wrong.

I am trying to create an invoice using an access report that shows subtotals of grouped products (with a rounded subtotal) which works perfectly, and then I want to sum these grouped rounded figures as a grand total in the report footer. The problem is when I manually add the subtotal figures...