Conditional expression help needed.

[dmschulz]

I am trying to write an expression for a report. It needs to count only yes
answers for a field and ignore all other answers. I know this should be easy
and I've searched the help files for 2 days now. All I have learned has been
self taught. If anyone can be of assistance I'd greatly appreciate it.
Thanks in advance,
Dawn

 

[Douglas J. Steele]

Assuming you're talking about a Boolean field (which Access misnames Yes/No
field), try

=Sum(IIf([NameOfField], 1, 0))

If you're actually talking about a text field that contains the letter Y,
try

=Sum(IIf([NameOfField] = "Y", 1, 0))

 

[dmschulz]

Thank you so much Doug. It worked perfectly.

Dawn

Assuming you're talking about a Boolean field (which Access misnames Yes/No
field), try

=Sum(IIf([NameOfField], 1, 0))

If you're actually talking about a text field that contains the letter Y,
try

=Sum(IIf([NameOfField] = "Y", 1, 0))

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am trying to write an expression for a report. It needs to count only yes
answers for a field and ignore all other answers. I know this should be
easy
and I've searched the help files for 2 days now. All I have learned has
been
self taught. If anyone can be of assistance I'd greatly appreciate it.
Thanks in advance,
Dawn