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>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar