You could use an aggregate query that would look something like this... SELECT myTable.account, Count(myTable.person_no) AS CountOfperson_no, Count(myTable.mail) AS CountOfmail FROM myTable GROUP BY myTable.account;
"Bradshaw, Peter A C301" <[EMAIL PROTECTED]> wrote: Given the following table: Account Person_no Mail 1111111 111223333 Y 1111111 222442222 Y 1111111 555222222 Y 1111111 444779999 2222222 666889999 Y 2222222 888334444 Y 2222222 999777777 2222222 999998888 2222222 111773333 3333333 888882222 3333333 000440000 I need to produce a spreadsheet (so I was thinking in terms of query) that will count Person_no's for each account AND count how many "Y" values it finds in the Mail field I need to see this: Account c_Per C_Mail 1111111 4 3 2222222 5 2 3333333 2 0 Pete Bradshaw Fulfillment Business Services Production Support CIGNA HealthCare 860.226.3019 (N:572.3019) mailto:[EMAIL PROTECTED] (c) 2006 - Unpublished, copyrighted materials. Intended solely for its intended recipients. If you have inadvertently received these materials not intended for you, please notify sender and delete all copies. ------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2006 CIGNA ============================================================================== [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Brings words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail. [Non-text portions of this message have been removed] 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/
