Sum totals in my report 2

[Newton]

I have a report showing the sell price and tax etc for different items coming up in a monthly report.

I am having troubles figuring the totals out. The report is based on a query, I know how to do calculations in a query stuff:[this]+[that]

but I cant quite make the sum function work, and the help example using the SUM field and group by ...I just dont understand.

How should I do the Sums? In the report or in the query? and how do I do that exactly?

TIA

 

[jjonesal]

Why don't you add an unbound text box control to your report and then set the control source property to:

=SUM([fieldname])


Hope this helps...

jjones@cybrtyme.com

 

[CosmoKramer]

Add a group footer to your report for whatever field you want to sum on. Add jjonesal's response, =SUM([fieldname]) and you should be all set.....

 

[Newton]

I am going to feel a little dumb, because the help print out said the same thing....how exactly does the unbound text box work...is that the ab button on my toolbox toolbar? and then where do i type =sum([fieldname]) in properties? and under what?

Thanks for your quick replys....I feel I am this close I understand to put the feilds in my report footer.

Newton

 

[jjonesal]

Yes, use the ab| button in your toolbox. Then, as CosmoKramer said add drag you a new text box in group footer for the group you want the subtotal for.

Add the =sum([fieldname] in the Control Source property.

 

[Newton]

Got it!!

Thanks so much