Totals (1 Viewer)

[sir_dan_mitchell]

hey,

I have a table that contains nummerical values that I would like to add up and display the total in a report! I want each value to be shown (simply the value in the field) and then at the bottom of the report I want the total of all the records.

however I want the totals to be 'sub totals' as I want the totals to be divided up into different groups. e.g. a total would appear at the bottom of each job type.

Finally then I would like a grand total at the end of the report! I have posted this in queries as I feel that the calculations will first have to be done in a query before they can be displayed.

I would appreciate a quick responce .

Thanks a lot guys

Dan

 

[Rich]

Sum the fields in the Group footer, you don't need to calculate them in a query

 

[sir_dan_mitchell]

how do I do this?

 

[Rich]

Use the report wizard to build the report, sorting grouping options will then be available to you