By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Report Group Section Footer displaying Totals

P: n/a
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 ***
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Susan Bricker wrote:
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)
You could use
=Sum(IIF(Qualified],1,0))
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 ***

Nov 13 '05 #2

P: n/a
Susan Bricker wrote in message <Lh***************@news.uswest.net> :
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 ***


Try
=ABS(Sum([score] Is Null))
=ABS(Sum([qualified]))

--
Roy-Vidar

Nov 13 '05 #3

P: n/a
Hey, Salad ...

That looks like it will do the trick. Thanks very mcuh.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.