Access 2007 syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tammy - 13 Sep 2007 16:56 GMT

I have a with field with yes/no values and need to count the number of "Y"
(yes)responses on a report. What syntax/code can I use to count only the Y
values?

Signature

Tammy

Reply to this Message

Douglas J. Steele - 13 Sep 2007 17:03 GMT

You can use the DCount Domain Aggregate function:

DCount("*", "[NameOfTable]", "[NameOfYesNoField] = True")

You can also use SQL:

SELECT Count(*) AS TotalYes
FROM NameOfTable
WHERE NameOfYesNoField = True

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have a with field with yes/no values and need to count the number of "Y"
> (yes)responses on a report. What syntax/code can I use to count only the
> Y
> values?

Reply to this Message