I have a group section footer in a Report in which I want to display
various "counts" (not sums).
For example:
some of the fields in the recordset from the query are:
score = integer
qualified = true/false
I want:
number of records with Score value of NULL ( I have ControlSource of the
textbox =Count(IsNull([score]))
number of records with qualified = True (I have ControlSource of the
textbox =Count([qualified]=True)
What I am getting is the total number of records in the selected group.
Not what I want.
Can you help?
Regards,
SueB
*** Sent via Developersdex http://www.developersdex.com ***