but that doesn't take into account I only want "Y" values counted.
- PETE
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Lonnie Johnson
Sent: Thursday, February 09, 2006 12:39 PM
To: [email protected]
Subject: Re: [ms_access] Summary query
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]
------------------------------------------------------------------------------
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]
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/
