Re: Count of Yes/no Field

"Martin" <Martin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4C083A24-3C06-4291-81FE-39C31000B3A8@xxxxxxxxxxxxxxxx
Hi,
I created a simple data base to count various task. Each field are Yes/No.
I'm unable to count into a report the amount of Yes for each row of a
table.

You need use count with a WHERE clause, i.e.,

SELECT Count(tblCustomer.Active) AS [Count]
FROM tblCustomer
WHERE (((tblCustomer.Active)=False));

Or if you wanted to use a domain function,

DCount("Active","tblCustomer","Active=True")


.

Loading