total in report help needed

[ndendrinos]

Just started using Access and in my first report I have three lines like this:

Tom.................................$10.00
****..................................$20.00
Harry.................................$.5.00
Harry.................................$32.00

I've tried to get a grand total in the footer and what I get is the total of the last line in the report : $32.00

What I need is a report that would look like this:

Tom..................................$10.00
Total.................................$10.00

****..................................$20.00
Total.................................$20.00

Harry.................................$.5.00
Harry.................................$32.00
Total.................................$37.00


Grand total (in the footing?).$67.00

Can I get help with this remonding any volunteer that I really never used Access before.
Many thanks

 

[Andrew Fergus]

Hi,

have a look at this web page, or this page or this page might be best.

HTH, Andrew.

 

[ndendrinos]

Thank you Andrew ... have downloaded the file from the best source and I should be able to get the results I need.
Regards,
Nick