Count on report, based on report, not query.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is based on a query. My report is grouped and I only
want the count on my footer to count what is shown on the report, not the
actual count from my query. I am trying to count cities. I have nineteen
records, which is what the count is giving me, however, grouped there are
only eight cities due to duplicate fields.

I used: =count([ATM CITY]) This retrieved a count of 19 instead of the
eight that show on the report.

I also tried: =count(reports![report1].[ATM CITY] This retrieved 0.

Any help would be appreciated!
 
J. Scadlock said:
I have a report that is based on a query. My report is grouped and I only
want the count on my footer to count what is shown on the report, not the
actual count from my query. I am trying to count cities. I have nineteen
records, which is what the count is giving me, however, grouped there are
only eight cities due to duplicate fields.
Click to expand...


Make sure your group has either a header or footer section
for the City field. Then add a text box named txtCityCount
to the header or footer and set its control source to =1 and
its RunningSum property to Over All.

A report footer text box can then display the number of
cities by using the simple expression =txtCityCount
 
Back
Top