Total from Header

  • Thread starter Thread starter Chas45
  • Start date Start date
C

Chas45

I have a report that has companys with items sold. The report shows the
company name as a header and then items in the detail section. There are 20
companies and I want the report to show the number of companies in the footer
but when I try to do a sum it totals based on the details since the query
shows the company name with each detail. Is there a way to just show a total
of the companies from the header?
 
Add a text box either on Report Header or Page Footer and enter the following
formula on its Control Course

=Count([NameOfTheFiledContainingCompanyNames])

hth
Adnan
 
Chas45 said:
I have a report that has companys with items sold. The report shows the
company name as a header and then items in the detail section. There are 20
companies and I want the report to show the number of companies in the footer
but when I try to do a sum it totals based on the details since the query
shows the company name with each detail. Is there a way to just show a total
of the companies from the header?
Click to expand...


To count the number of companies, add a text box (named
txtCnt) to the group header section. Set it's control
source expression to =1 and its RunningSum property to Over
All

Then a report footer text box can display the number by
using the expression =txtCnt
 
Back
Top