calculating column totals in a report

[R Marko]

I’m calculating payroll in a report:

Column 1
Begin Time

Column 2
End Time

Column 3
=DateDiff("n",[ActualBegin],[ActualEnd])/60

Column 4 - Hourly Rate

Column 5 - Actual Pay
=IIf([TotalHrs]*[Salary]>50,[TotalHrs]*[Salary],50)

Column 6 is an Override (to override previous calculations)

Column 7 - Expenses

Column 8 - TotalPay
=IIf(IsNull([Override]),[ActualPay],[Override])

Column 9 - Total
=[TotalPay]+[Expenses]

The calculations work perfectly but I cannot get the columns to add.
The fields where there are calculations i.e. ActualPay and TotalPay have the
code written directly into the field.

When I insert a field with:
=sum([ActualPay])
I get an error message where it does not recognize “ActualPayâ€

Please help!
Rhonda Marko

 

[LLKHOUTX]

Sum your report fields in a report footer.

 

[R Marko]

Unfortunately, I need the sum in the detail footer and it's not working.

Sum your report fields in a report footer.
--
LLKHOUTX

I’m calculating payroll in a report:

Column 1
Begin Time

Column 2
End Time

Column 3
=DateDiff("n",[ActualBegin],[ActualEnd])/60

Column 4 - Hourly Rate

Column 5 - Actual Pay
=IIf([TotalHrs]*[Salary]>50,[TotalHrs]*[Salary],50)

Column 6 is an Override (to override previous calculations)

Column 7 - Expenses

Column 8 - TotalPay
=IIf(IsNull([Override]),[ActualPay],[Override])

Column 9 - Total
=[TotalPay]+[Expenses]

The calculations work perfectly but I cannot get the columns to add.
The fields where there are calculations i.e. ActualPay and TotalPay have the
code written directly into the field.

When I insert a field with:
=sum([ActualPay])
I get an error message where it does not recognize “ActualPayâ€

Please help!
Rhonda Marko

 

[Duane Hookom]

You can't sum controls. You can sum expressions. Try something like:
=Sum( IIf([TotalHrs]*[Salary]>50,[TotalHrs]*[Salary],50))
If any of the above are calculated, replace it with the calculation.

 

[Tom Lake]

The calculations work perfectly but I cannot get the columns to add.

The fields where there are calculations i.e. ActualPay and TotalPay have
the
code written directly into the field.

When I insert a field with:
=sum([ActualPay])
I get an error message where it does not recognize "ActualPay"

You can't Sum a calculated field. You have to do this to sum ActualPay:

=Sum(IIf([TotalHrs]*[Salary]>50,[TotalHrs]*[Salary],50))

Tom Lake