Count in Detail Section

[foxhsu via AccessMonster.com]

My report looks like this. I made 0004 invisible already, so it won't show in
subreport, but how do I made the total sample count as 4? I use Count(ID#),
but it still gave me 5.

Thank you
foxhsu

<main report>
Client Name

ID number Date
-------------- ------------
0001 07/01/05
0002 07/01/05
0003 07/01/05
0004 08/01/05
0005 08/01/05

Detail <subreport,on the same page or next page>

ID # result detail1
-------- ------------- ----------------
0001 xxxx xxxxxx
0002 xxxx xxxxxx
0003 xxxx xxxxxx

0005 xxxx xxxxxx

total sample: 5

 

[fredg]

My report looks like this. I made 0004 invisible already, so it won't show in
subreport, but how do I made the total sample count as 4? I use Count(ID#),
but it still gave me 5.

Thank you
foxhsu

<main report>
Client Name

ID number Date
-------------- ------------
0001 07/01/05
0002 07/01/05
0003 07/01/05
0004 08/01/05
0005 08/01/05

Detail <subreport,on the same page or next page>

ID # result detail1
-------- ------------- ----------------
0001 xxxx xxxxxx
0002 xxxx xxxxxx
0003 xxxx xxxxxx

0005 xxxx xxxxxx

total sample: 5

=Sum(IIf([ID#)<>4,1,0)