A
Aurora
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
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