Robin, I wonder if you're going to have to do 2 different queries and then a union query.
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 06, 2015 4:18 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Count of count
I have a query that counts males and females in my datatbase.
SELECT Count(Data.fFirstName) AS CountOffFirstName,
Count(Data.mFirstName) AS CountOfmFirstName FROM Data HAVING (((Count(Data.fFirstName)) Is Not Null));
Is it possible to calculate total residents within the same query?
Some residents are couples and are just one record in the table.
Many thanks,
Robin Chapple
------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary 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.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar