Count Number of Yes's in a Yes/No field

G

Guest

I have two Yes/No fields, one for Contract Awarded and one for Contract Lost.
When I run a report I would like a count of each field. That way I know how
many proposals are still outstanding (based on how many have been sent) and
can use that info to calculate award percentages and outstanding percentages,
etc. Thanks for your help in advance.
 
R

Rick Brandt

Suliman said:
I have two Yes/No fields, one for Contract Awarded and one for Contract Lost.
When I run a report I would like a count of each field. That way I know how
many proposals are still outstanding (based on how many have been sent) and
can use that info to calculate award percentages and outstanding percentages,
etc. Thanks for your help in advance.
Click to expand...

Since "Yes" values are stored as negative one you can simply sum those fields
and then get the absolute value.

=Abs(Sum([Contract Awarded])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing and counting in Reports 4
Count Only Yes checks in Access Report 1
Count Yes/No field in report? 2
Trouble with my sorting and grouping 2
Count if 1
Reporting total of Yes 3
displaying the number of Yes's in a Yes/No field 3
Summing Amount from Records with Yes checked off in Awarded field 3

Top