Count in Detail Section

  • Thread starter Thread starter foxhsu via AccessMonster.com
  • Start date Start date
F

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
 
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
Click to expand...

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