count(*) returning total group count

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

Guest

I am using the =Count(*) function in a text box within the header of a group.
This normally will just count the number of records within each of the
groups. However, for some reason, I am getting what appears to be an overall
count of the records in the group first and then the count of each of the
groupings.

It looks like:
658
2 First Group
3 Second Group,
etc.

I have used this before and only got the count per group, which is what I
want. Where is the first count number comming from? I only have one text box
with the function in it. How can I loose the first count?

Any help will be appreciated.

Mr B
 
Mr said:
I am using the =Count(*) function in a text box within the header of a group.
This normally will just count the number of records within each of the
groups. However, for some reason, I am getting what appears to be an overall
count of the records in the group first and then the count of each of the
groupings.

It looks like:
658
2 First Group
3 Second Group,
etc.

I have used this before and only got the count per group, which is what I
want. Where is the first count number comming from? I only have one text box
with the function in it. How can I loose the first count?
Click to expand...


It sounds like you also have a count text box in the report
header section.

If that's not it, then try to open the report's record
source query from the query design window and check if the
grouping field has 658 records with a Null value.
 
Back
Top