Counting # groups (all)

Topic

New Reply

I’ve been working on my house for past 6 weeks or so, and I think the paint fumes have finally gotten to me. I can’t seem to focus.

I’ve got a relatively simple report, in which the detail section shows Invoice information, and there is a grouping footer showing Customer Totals, and a Report Footer showing Report Totals. I want to show the # of customers in the report; that is, the report might have 20 invoices for 8 customers. The normal =Count(*) shows 20. How do I get a count of the # of customers?

Reply | Quote

Replies

Put a text box tstRunningCount in the group header or footer for Customer.
Set its Control Source to =1.
Set its Runing Sum property to Over All.
Set its Visible property to No.

Put a text box txtCount in the report footer.
Set its Control Source to =[txtRunningCount].

Reply | Quote

Hans,

Thanks! That did it.

I had already created that control in the footer (without the Running Sum), but then tried to do a =Sum(controlname), and it didn’t like it.

Reply | Quote

You can’t use expressions such as Sum(controlname) in a report, only Sum(fieldname) and similar.

Reply | Quote