Avoiding duplicate counting

[Kim W. via AccessMonster.com]

I am posting this for a co-worker:

I need to count a value in a field that is giving me duplicate counts.
My report looks like:
CRN INTEGRATION CODE DAY HRS/WK BLD
70125 HYBRID TBA 3.00
WEB
HYBRID MW 1.5
HS
73247 ONLIN TBA 3.50
WEB
76543 WBENH TTh 1.50
AC
WBENH T 2.00
AC


I am trying to count the type of courses under integration code. As you can
see my count value on some is counting the value twice. Is there a way I
can count the value of integration code without getting a duplicate value per
single CRN? I tried this if expression but got a null count.

=IIf([INTEGRATION_CODE]="HYBRID",Count([CRN]))

Thanks so much for your help,
LaDonna

 

[Marshall Barton]

I need to count a value in a field that is giving me duplicate counts.
My report looks like:
CRN INTEGRATION CODE DAY HRS/WK BLD
70125 HYBRID TBA 3.00
WEB
HYBRID MW 1.5
HS
73247 ONLIN TBA 3.50
WEB
76543 WBENH TTh 1.50
AC
WBENH T 2.00
AC


I am trying to count the type of courses under integration code. As you can
see my count value on some is counting the value twice. Is there a way I
can count the value of integration code without getting a duplicate value per
single CRN? I tried this if expression but got a null count.

=IIf([INTEGRATION_CODE]="HYBRID",Count([CRN]))

I don't see a count in your example.

If you only want to count HYBRID once, create a group on the
INTEGRATION_CODE field. In the group header or footer
section (does not need to be visible), add a text box (named
txtCount) and set its expression to =1 and RunningSum to
Over Group. Then the CRN group footer can display the count
in a text box by using the expression =txtCount