Counting Groups in a Report

  • Thread starter Thread starter cclark
  • Start date Start date
C

cclark

I have a report that groups on a_id. a_id may have 3 records underneath it
but I want to do a count at the end of the report that only counts a_id one
time.

A quick eample of what it does now:

A_ID Day
001
Today
Yesterday
Tomorrow
002
Today
Yesterday

Total 5

I would like for the total to be 2 because there are only 2 groups. Any
assistance will be appreciated.

Thanks
 
Thanks Guys,

I was able to figure it out. I added a text box in the group header section
and set the control source =1 and visible = no and running sum = over all.
Then I added a text box in report footer and set the control source to the
name of the new text box that I put in the group header section.

Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to extract GPS tags from a image 6
Option groups, radio buttons and reports...oh my!! 7
grouping for report 6
Excel Formula - Count Dates from another Sheet 8
Count in a Report Footer of a Report 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
hours, minutes, seconds 4
Trying to not count duplicates in a report 12

Back
Top