Say I have a table with clientID, category1, category2, category3. Now each row is unique, but the combination of clientid and category1 may not be. If I just want the count of clientid for each possible value of category 1, that works. The question is, can I get a count of the number of UNIQUE client ids for each possible value of category1.
What I actually need to accomplish is this:
I have a master table with clientid (unique), category1, category3. There is a child table with clientid, category2. Neither column is unique, but the combination is. I need one report that gives me a count of the unique number ids of each possible value of category1, the same for category3 and a count of the number of ids for category2. I can get each one separately using the crosstab feature quite nicely. But, if I want it altogether, I see no other way than a view, which will give me multiple occurrences of clientid+category1 or clientid+category3 combinations. Perhaps I should try subreports?
--
Kayza Kleinman
Director, Nonprofit Helpdesk
Jewish Community Council of Greater Coney Island, Inc.
3001 West 37th Street
Brooklyn, NY 11224
Tel. 718 449-5000
Fax 718 946-8240
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
www.nphd.org <http://www.nonprofithelpdesk.org/>
“Putting Technology to Work For You”
