Sum of sub totals

[Guest]

I am using Access 2003.
I have a report that lists quotes (including each line item within the
quote) by sales person. Per Duane Hookom I added a text box with a control
source = 1, so that I could count the number of "quotes only" per
salesperson. The name of this text box is "txtquotecount". This works
fine. Now at the end of the report I want to add the quotes by salesperson
for a total # of quotes for the month. I tried =sum([txtquotecount]) and
other varations but nothing has worked. I even tried =count(*), but this
counts all the line items. Does anyone have any ideas of how to do this????

Aurora

 

[Marshall Barton]

I am using Access 2003.
I have a report that lists quotes (including each line item within the
quote) by sales person. Per Duane Hookom I added a text box with a control
source = 1, so that I could count the number of "quotes only" per
salesperson. The name of this text box is "txtquotecount". This works
fine. Now at the end of the report I want to add the quotes by salesperson
for a total # of quotes for the month. I tried =sum([txtquotecount]) and
other varations but nothing has worked. I even tried =count(*), but this
counts all the line items. Does anyone have any ideas of how to do this????

Add another text box =1 text box, but set its Running Sum
property to Over All.