Counting Text Items

D

Debbie D.

Hi all,

I have a report that works perfert for me needs except.. I have a group
colum that is named: TestMode with a control of the same name. There are
only two posbibilites for this field, TEST or PRIMER. I wish to use a group
total that will detail how many 'TEST' or 'PRIMER' there are. I have tried
the following below but it either returns a 0 or 1. The report iteselfs
shows all the correct details. Any help appreciated and many thanks to all.

=Count(IIf([TestMode]="TEST",1,0))

Debbie D.
 
D

Duane Hookom

Use control sources like the following in a report or group header or
footer.

=Sum(IIf([TestMode]="TEST",1,0))
or
=Sum(Abs([TestMode]="TEST"))
 
D

Debbie D.

Duane,

What a SuperStar!! Many thanks for your quick and helpful reply. Thanks DD.

Duane Hookom said:
Use control sources like the following in a report or group header or
footer.

=Sum(IIf([TestMode]="TEST",1,0))
or
=Sum(Abs([TestMode]="TEST"))



--
Duane Hookom
MS Access MVP
--

Debbie D. said:
Hi all,

I have a report that works perfert for me needs except.. I have a group
colum that is named: TestMode with a control of the same name. There are
only two posbibilites for this field, TEST or PRIMER. I wish to use a
group
total that will detail how many 'TEST' or 'PRIMER' there are. I have
tried
the following below but it either returns a 0 or 1. The report iteselfs
shows all the correct details. Any help appreciated and many thanks to
all.

=Count(IIf([TestMode]="TEST",1,0))

Debbie D.
Click to expand...
Click to expand...
 
Top