Trying to total a calculated field form a group footer in another group footer (1 Viewer)

[Deputy91]

I am trying to total the FLSA Cash for all of the pay weeks for one employee (group) above. FLSA Cash is a calculated fields using AVG([Work Week]), SUM([OTCASH], SUM([OTCOMP]), SUM([LEAVE]) and AVG([Hourly])

I believe that I may have to setup a query to do the calculation, but how do I do that with fields from the report?

I also want a grand total for all employees at the end of the report. I think if I get past the first calculated field issue, everything else will fall into place.

the report is grouped by employee then by pay week. HELP!

 

[mike60smart]

I am trying to total the FLSA Cash for all of the pay weeks for one employee (group) above. FLSA Cash is a calculated fields using AVG([Work Week]), SUM([OTCASH], SUM([OTCOMP]), SUM([LEAVE]) and AVG([Hourly])

I believe that I may have to setup a query to do the calculation, but how do I do that with fields from the report?

I also want a grand total for all employees at the end of the report. I think if I get past the first calculated field issue, everything else will fall into place.

the report is grouped by employee then by pay week. HELP!

Hi
Are you able to upload a copy of the database with no confidential data?

 

[Gasman]

Crossposted at https://www.accessforums.net/showthread.php?t=91069

 

[Pat Hartman]

You haven't given us enough to work with but my first guess is that you are referencing control names to create your total but you need to actually recreate the calculation:

=SUM([OTCASH]) + SUM([OTCOMP]) + SUM([LEAVE]) +AVG([Hourly]))
rather than
=Sum(CashSum + CompSum + LeaveSum + HoulySum)

 

[Deputy91]

SOLVED:

Thank you. Mike60Smart was a lifesaver. He fixed and walked m through the solution - and how to build queries.

 

[mike60smart]

You haven't given us enough to work with but my first guess is that you are referencing control names to create your total but you need to actually recreate the calculation:

=SUM([OTCASH]) + SUM([OTCOMP]) + SUM([LEAVE]) +AVG([Hourly]))
rather than
=Sum(CashSum + CompSum + LeaveSum + HoulySum)

Hi Pat
I have spoken with the OP and explained to him that all his calculations should be carried out in a query rather than in the Report it self.
His problems have now been resolved.

 

[Pat Hartman]

That is frequently the better way but my explanation is still important. Was that the problem the OP was having?

 

[mike60smart]

That is frequently the better way but my explanation is still important. Was that the problem the OP was having?

Hi Pat
Yes. Also the fact that fields in tables which were supposed to be numeric were in fact text due to Import from an Excel file.

 

[Pat Hartman]

Thanks for confirming that because sometimes, it is actually necessary to code the sums on the Report rather than in the query. Understanding the problem will help others.