Group Sub Totals

[danielw.au]

Hi Everyone,

I have a database where my team will enter manual payment calculations into. Once entered, they will run and print the report for actual payment.

The report I have groups by payment type (see attached image of paymetn types) and then sub totals by group.

I need to somehow get these totals and use them to generate a gross payment. In the attached example, the gross would be the sum of worked hours + before tax allowance + after tax allowance. I'm not sure how I can do this in the group footer.

If anyone has any suggestions, I'd be greatful. I have attached images.

Thank you.
Daniel

 

[vbaInet]

It can be done in a query. Have a look at the following links:

http://office.microsoft.com/en-gb/access-help/display-column-totals-in-a-datasheet-HA001233062.aspx
http://www.fontstuff.com/access/acctut04.htm
http://office.microsoft.com/en-gb/access-help/sum-data-by-using-a-query-HA010096310.aspx