Grand Total in Report

R

Richardb

I have a report that totals seconds and than converts to hours.

The "SumOfTIMEINSECONDS" is in the detail which comes from query.

The "=Sum([SumOfTIMEINSECONDS]/3600)-8" is in the footer and converts to
hours for each employee.

I want to take the results for each employee of the
=Sum([SumOfTIMEINSECONDS]/3600)-8 and have a grand total for all in the
report footer for the hours.

My formula is not giving me the right results. I have tried several
different ways.

Any suggestions would be greatly appreciated.

Richard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Grand Total Miscalculating Overtime 5
Group Totals and Grand Totals on each page 3
Grand Total for a calculated column - Access 2007 1
Filter on Grand Total 2
One and One-half Columns and Grand Total on Same Page (?) 5
Grand total 2
Calculating overtime in report footer 2
Sum function in report not working properly 5

Top