Summarizing Totals on a Report

[Scorpion]

Is there any way to have a report summarize the totals that are calculated on it.

For example:

I want to generate a report that calculates out payroll hours & amounts for each person in a pay period. The report lists out each day that the employee worked in the pay period and calculated out their pay for that day. I then total all of the days in the period for a total of what I will pay them.

What I need to know is if it is possible to have Access generate a summary report of each employees period totals and list all employees together on one page. I could probably create a new report to accomplish this but I am hoping that I can have this report generate at the same time and be veiwed as a separate page.

 

[KevinM]

You need to create a 'Totals Query' first and then create a report based on this.