ACCESS02 DCount() in Report Group Footer

  • Thread starter Thread starter Glenda
  • Start date Start date
G

Glenda

I have a report with 1 grouping. I need a column count in
each group footer based on specified criteria from
another column. I am told that I can only do this with
Dcount(). That was not my understanding of its use but I
tried it anyway. I am getting it to count based on my
criteria but it will only produce numbers for the whole
report even though it is in the group footer.

Any suggestions???
Glenda
 
You rarely if ever should use DCount() or other domain aggregate functions
in reports. If you want a count of the number of records where a [Gender]
field is "F" then add a text box with a control source of:
=Abs(Sum([Gender]="F"))
To total the Salary field where Gender ="F"
=Abs(Sum([Gender]="F" * [Salary]))

Duane Hookom
MS Access MVP
 
Back
Top