[AccessD] Access 2k - Report group counter

O'Connor, Patricia (OTDA) Patricia.O'Connor at otda.state.ny.us
Wed Apr 19 11:41:16 CDT 2006


I have a report where I want to count the number of unique People in a
group that received checks.  If I tried to count the PEOPLE_ID I get a
count of the number of checks. I know this has been discussed before but
I just cant find it.  
   Grp1
     p1  ch1
         ch2
        Total amt  <checkcnt>
     p2  ch1
        total amt  <checkcnt>
GRP1 total people 3    --- instead of 2  If I try to count the group
total line COUNT checkcnt in another group it won't let me do that 

Been fighting this all morning and in a bit of a rush.

Thanks
**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at nysemail.state.ny.us
************************************************** 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system.



More information about the AccessD mailing list