Count in Detail Section

  • Thread starter foxhsu via AccessMonster.com
  • 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
 
Ad

Advertisements

F

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Detail Section 2
Section Detail 1
Detail section 4
Detail Section Limitations 2
dlookup in detail section 1
Hiding Section Detail 7
report detail section 2
reposition the detail section 3

Top