totals in a report 2

[mrblonde]

I'm not used to creating reports without the wizard. Anyhow, I have three fields I would like to get a total for. I figured I would use a label, but does it go in the footer? Also, do I use the caption property of the label to perform the sum? Lastly, what would I type in to sum a field named, Billed?

Thanks
Mat

"You never know what you have until it's gone...I wanted to know what I had, so I got rid of everything." -Steven Wright

 

[DougAtAvalon]

Try this

Make a text box not a label (I think in the footer)

the control source property should be =Sum([ControlName])

That should be it1

-Doug

 

[ghubbell]

Hi Mat,
It'll have to be a Text box and it's control source should look something like:

=Sum([Billed])

Watch the "Running Sum" property as you can play with this and get different results and depending on your "grouping" in the report can decide where you want the "sum". Try one, copy/paste and move the second one elsewhere..i.e. another section of the report. See how things "add up".! Gord
ghubbell@total.net