ACCESS02 DCount() in Report Group Footer

[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

 

[Duane Hookom]

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