Count & Yes/No fields

[Peter]

Hi, Help please !!!
I have a large database with a number of Yes/No fields. I
want count the Yes fields and have these numbers in the
data area in a pivot table - can this be done?

 

[Niklas Östergren]

Hi Peter!

You can make a select query where you select only fields with "Yes" and then
use DCount() to count number of records in that query.

// Niklas

 

[Guest]

Thanks, Niklas, I'll give it a try.

-----Original Message-----
Hi Peter!

You can make a select query where you select only fields with "Yes" and then
use DCount() to count number of records in that query.

// Niklas


"Peter" <[email protected]> skrev i meddelandet


.

 

[Duane Hookom]

To "Count" the Yes values of a Yes/No field, you sum its absolute value
Sum(Abs([YourField]))
To "Count" the No values of a Yes/No field, you sum its value + 1
Sum([YourField] +1)

 

[Peter]

Thanks Duane - works a treat!!

-----Original Message-----
To "Count" the Yes values of a Yes/No field, you sum its absolute value
Sum(Abs([YourField]))
To "Count" the No values of a Yes/No field, you sum its value + 1
Sum([YourField] +1)

--
Duane Hookom
MS Access MVP
--

Hi, Help please !!!
I have a large database with a number of Yes/No fields. I
want count the Yes fields and have these numbers in the
data area in a pivot table - can this be done?

.