Grand totals

[Guest]

In my group footer I have the following calculation named Group totals:
=[text30]+[text38]
This gives me the correct numbers. Now in my report footer I want to total
up the previous calculation. I've tried =[Grouptotals] and all this displays
is the last found record totals. Thank you in advance.

 

[Duane Hookom]

You can't sum controls. You can sum the fields or expressions from the
report's record source. You haven't provided this information.

 

[Guest]

I'm a little confused. The report's record source is a query with no
criteria. Text 30 (which is unbound)contains the following:
=IIf([elm/ven]="e",Sum([total cost]),0). Text 38 (also unbound) contains:
=IIf([Elm/Ven]="e",[text34]*0.017,0). Is this what you're asking for?
--
Thank you,
Shirley

You can't sum controls. You can sum the fields or expressions from the
report's record source. You haven't provided this information.

--
Duane Hookom
MS Access MVP

In my group footer I have the following calculation named Group totals:
=[text30]+[text38]
This gives me the correct numbers. Now in my report footer I want to
total
up the previous calculation. I've tried =[Grouptotals] and all this
displays
is the last found record totals. Thank you in advance.

 

[Duane Hookom]

I don't understand you logic. You can duplicate your controls, make them
invisible and set their running sum to over all. Then reference these
controls in your report footer.

--
Duane Hookom
MS Access MVP

I'm a little confused. The report's record source is a query with no
criteria. Text 30 (which is unbound)contains the following:
=IIf([elm/ven]="e",Sum([total cost]),0). Text 38 (also unbound) contains:
=IIf([Elm/Ven]="e",[text34]*0.017,0). Is this what you're asking for?
--
Thank you,
Shirley

You can't sum controls. You can sum the fields or expressions from the
report's record source. You haven't provided this information.

--
Duane Hookom
MS Access MVP

In my group footer I have the following calculation named Group totals:
=[text30]+[text38]
This gives me the correct numbers. Now in my report footer I want to
total
up the previous calculation. I've tried =[Grouptotals] and all this
displays
is the last found record totals. Thank you in advance.

 

[Guest]

That worked great. Thank you and sorry for the confusing
--
Thank you,
Shirley

I don't understand you logic. You can duplicate your controls, make them
invisible and set their running sum to over all. Then reference these
controls in your report footer.

--
Duane Hookom
MS Access MVP

I'm a little confused. The report's record source is a query with no
criteria. Text 30 (which is unbound)contains the following:
=IIf([elm/ven]="e",Sum([total cost]),0). Text 38 (also unbound) contains:
=IIf([Elm/Ven]="e",[text34]*0.017,0). Is this what you're asking for?
--
Thank you,
Shirley

You can't sum controls. You can sum the fields or expressions from the
report's record source. You haven't provided this information.

--
Duane Hookom
MS Access MVP


In my group footer I have the following calculation named Group totals:
=[text30]+[text38]
This gives me the correct numbers. Now in my report footer I want to
total
up the previous calculation. I've tried =[Grouptotals] and all this
displays
is the last found record totals. Thank you in advance.

 

[Guest]

ahhhhh...

this answers my other question. don't know why this didnt occur to me.

"You can't calculate controls." d'oh!

/amelia

I don't understand you logic. You can duplicate your controls, make them
invisible and set their running sum to over all. Then reference these
controls in your report footer.

--
Duane Hookom
MS Access MVP

I'm a little confused. The report's record source is a query with no
criteria. Text 30 (which is unbound)contains the following:
=IIf([elm/ven]="e",Sum([total cost]),0). Text 38 (also unbound) contains:
=IIf([Elm/Ven]="e",[text34]*0.017,0). Is this what you're asking for?
--
Thank you,
Shirley

You can't sum controls. You can sum the fields or expressions from the
report's record source. You haven't provided this information.

--
Duane Hookom
MS Access MVP


In my group footer I have the following calculation named Group totals:
=[text30]+[text38]
This gives me the correct numbers. Now in my report footer I want to
total
up the previous calculation. I've tried =[Grouptotals] and all this
displays
is the last found record totals. Thank you in advance.