Group, Need some assistance in setting up this query. I am trying to get a count of clients who have only one case and exclude clients who have more than one case associated with their SSN. We have some instances where a client has more than one case associated with their SSN...we do not want them counted. How would this query look? Here are the field names: client_ssn case_num TIA, Thanks, Isaiah Vi Information Technology Analyst County of San Mateo Human Services Agency Business Systems Group 400 Harbor Boulevard, Building C Belmont, CA 94002 (650) 802-5194 [Direct Line] (650) 802-6490 [Fax] [EMAIL PROTECTED] www.smchsa.org "In God we trust. All others must use data." ~W.E. Deming _______________________________ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of intended recipient(s) and may contain confidential and protected information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _______________________________
---------- BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Isaiah Vi ORG:;HSA EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED] N:Vi;Isaiah END:VCARD BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Vi, Isaiah ORG:;HSA EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED] N:Vi;Isaiah END:VCARD BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Vi, Isaiah ORG:;HSA EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED] N:Vi;Isaiah END:VCARD [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
