Report Group Section Footer displaying Totals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan Bricker - 31 Jul 2005 15:32 GMT

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

Reply to this Message

Salad - 31 Jul 2005 17:49 GMT

> I have a group section footer in a Report in which I want to display
> various "counts" (not sums).
[quoted text clipped - 11 lines]
> 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.
[quoted text clipped - 5 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message

Susan Bricker - 31 Jul 2005 19:45 GMT

Hey, Salad ...

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

Regards,
SueB

Reply to this Message

RoyVidar - 31 Jul 2005 19:38 GMT

Susan Bricker wrote in message <Lh5He.10$wN3.6307@news.uswest.net> :

> I have a group section footer in a Report in which I want to display
> various "counts" (not sums).
[quoted text clipped - 21 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

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

Signature

Roy-Vidar

Reply to this Message