Count

R

Rick_C

First let me apologize if this becomes a double post. I tried via Outlook and
I think things got screwed up...

This is my problem and question:

I have a field that is populated with either a YES, NO or REFUSED via a
combo box.

In my report, I am trying to capture only the count that pertains to YES.

In the control source of the field in the report I have:

=Count([FieldName]="Yes")

This gives me the count for all (YES/NO/REFUSED)

How can I filter so that I only get the count for the YES.

Thank you in advance for your assistance...

Rick
 
R

Rob Parker

Hi Rick,

If you don't have the count available in the recordsource (query) of your
report, the simplest way is probably to just use dCount. Set the control
source to:
=dCount("*","[TableOrQueryName]","[FieldName] = 'Yes'")

Check out the help file, under Domain Aggregate Functions.

HTH,

Rob
 
L

luanhoxung

First let me apologize if this becomes a double post. I tried via Outlook and
I think things got screwed up...

This is my problem and question:

I have a field that is populated with either a YES, NO or REFUSED via a
combo box.

In my report, I am trying to capture only the count that pertains to YES.

In the control source of the field in the report I have:

=Count([FieldName]="Yes")

This gives me the count for all (YES/NO/REFUSED)

How can I filter so that I only get the count for the YES.

Thank you in advance for your assistance...

Rick
Click to expand...

Try:
=Abs(Sum([FieldName]="Yes"))
 
R

Rick_C

Thank you for the responses. It's working like a charm.

[email protected] said:
First let me apologize if this becomes a double post. I tried via Outlook and
I think things got screwed up...

This is my problem and question:

I have a field that is populated with either a YES, NO or REFUSED via a
combo box.

In my report, I am trying to capture only the count that pertains to YES.

In the control source of the field in the report I have:

=Count([FieldName]="Yes")

This gives me the count for all (YES/NO/REFUSED)

How can I filter so that I only get the count for the YES.

Thank you in advance for your assistance...

Rick
Click to expand...

Try:
=Abs(Sum([FieldName]="Yes"))
Click to expand...
 
Top