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.