Payrol Totals Report

V

visidro

I have a payrol report that calculates the time worked and the amount earned
for each record
the time worked is: =[time finish]-[time start]
the amount earned is: =((Hour([total hours])*60+Minute([total
hours]))/60)*[rate]

I would like to calculate the total amount earned for the group,
thanks
 
D

Duane Hookom

Isn't the total amount earned something like:
=Sum( ([Time Finish]-[Time Start]) * 24 * [HourlyRate] )
 
V

visidro

Thanks Duane, but I get an error.
I guess my question should be: how do you total a calculated column. The
amount earned is calculated for each row and I want to total all the rows in
the group footer.

Duane Hookom said:
Isn't the total amount earned something like:
=Sum( ([Time Finish]-[Time Start]) * 24 * [HourlyRate] )
--
Duane Hookom
Microsoft Access MVP


visidro said:
I have a payrol report that calculates the time worked and the amount earned
for each record
the time worked is: =[time finish]-[time start]
the amount earned is: =((Hour([total hours])*60+Minute([total
hours]))/60)*[rate]

I would like to calculate the total amount earned for the group,
thanks
 
D

Duane Hookom

You can't total a calculated "control" across report sections. You can only
total/sum values/expressions from your report's record source.

--
Duane Hookom
Microsoft Access MVP


visidro said:
Thanks Duane, but I get an error.
I guess my question should be: how do you total a calculated column. The
amount earned is calculated for each row and I want to total all the rows in
the group footer.

Duane Hookom said:
Isn't the total amount earned something like:
=Sum( ([Time Finish]-[Time Start]) * 24 * [HourlyRate] )
--
Duane Hookom
Microsoft Access MVP


visidro said:
I have a payrol report that calculates the time worked and the amount earned
for each record
the time worked is: =[time finish]-[time start]
the amount earned is: =((Hour([total hours])*60+Minute([total
hours]))/60)*[rate]

I would like to calculate the total amount earned for the group,
thanks
 
V

visidro

I see. I have a running total for each record now .... could I do something
to just capture the last Total?. Sorry Duane I am new with access, hope I am
explaining my self.

Duane Hookom said:
You can't total a calculated "control" across report sections. You can only
total/sum values/expressions from your report's record source.

--
Duane Hookom
Microsoft Access MVP


visidro said:
Thanks Duane, but I get an error.
I guess my question should be: how do you total a calculated column. The
amount earned is calculated for each row and I want to total all the rows in
the group footer.

Duane Hookom said:
Isn't the total amount earned something like:
=Sum( ([Time Finish]-[Time Start]) * 24 * [HourlyRate] )
--
Duane Hookom
Microsoft Access MVP


:

I have a payrol report that calculates the time worked and the amount earned
for each record
the time worked is: =[time finish]-[time start]
the amount earned is: =((Hour([total hours])*60+Minute([total
hours]))/60)*[rate]

I would like to calculate the total amount earned for the group,
thanks
 
D

Duane Hookom

I generally try to calculate totals without using running sums. For instance
if a control source in the detail section is something like:
Name: txtNetPrice
Control Source: =[Quantity] * [UnitPrice] * IIf([Quantity]>=100,0.95,1)

I would add a text box to a footer with a control source of:
Control Source: =Sum([Quantity] * [UnitPrice] * IIf([Quantity]>=100,0.95,1))

You might get the same value if you set the Running Sum on
Name: txtNetPrice
Control Source: =[Quantity] * [UnitPrice] * IIf([Quantity]>=100,0.95,1)
Running Sum: Over All

and control source in the footer to:
Control Source: =txtNetPrice

--
Duane Hookom
Microsoft Access MVP


visidro said:
I see. I have a running total for each record now .... could I do something
to just capture the last Total?. Sorry Duane I am new with access, hope I am
explaining my self.

Duane Hookom said:
You can't total a calculated "control" across report sections. You can only
total/sum values/expressions from your report's record source.

--
Duane Hookom
Microsoft Access MVP


visidro said:
Thanks Duane, but I get an error.
I guess my question should be: how do you total a calculated column. The
amount earned is calculated for each row and I want to total all the rows in
the group footer.

:

Isn't the total amount earned something like:
=Sum( ([Time Finish]-[Time Start]) * 24 * [HourlyRate] )
--
Duane Hookom
Microsoft Access MVP


:

I have a payrol report that calculates the time worked and the amount earned
for each record
the time worked is: =[time finish]-[time start]
the amount earned is: =((Hour([total hours])*60+Minute([total
hours]))/60)*[rate]

I would like to calculate the total amount earned for the group,
thanks
 
V

visidro

that's great Duane, that works. thank you very much
Victor

Duane Hookom said:
I generally try to calculate totals without using running sums. For instance
if a control source in the detail section is something like:
Name: txtNetPrice
Control Source: =[Quantity] * [UnitPrice] * IIf([Quantity]>=100,0.95,1)

I would add a text box to a footer with a control source of:
Control Source: =Sum([Quantity] * [UnitPrice] * IIf([Quantity]>=100,0.95,1))

You might get the same value if you set the Running Sum on
Name: txtNetPrice
Control Source: =[Quantity] * [UnitPrice] * IIf([Quantity]>=100,0.95,1)
Running Sum: Over All

and control source in the footer to:
Control Source: =txtNetPrice

--
Duane Hookom
Microsoft Access MVP


visidro said:
I see. I have a running total for each record now .... could I do something
to just capture the last Total?. Sorry Duane I am new with access, hope I am
explaining my self.

Duane Hookom said:
You can't total a calculated "control" across report sections. You can only
total/sum values/expressions from your report's record source.

--
Duane Hookom
Microsoft Access MVP


:

Thanks Duane, but I get an error.
I guess my question should be: how do you total a calculated column. The
amount earned is calculated for each row and I want to total all the rows in
the group footer.

:

Isn't the total amount earned something like:
=Sum( ([Time Finish]-[Time Start]) * 24 * [HourlyRate] )
--
Duane Hookom
Microsoft Access MVP


:

I have a payrol report that calculates the time worked and the amount earned
for each record
the time worked is: =[time finish]-[time start]
the amount earned is: =((Hour([total hours])*60+Minute([total
hours]))/60)*[rate]

I would like to calculate the total amount earned for the group,
thanks
 

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

Top