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
