Count & Yes/No fields

  • Thread starter Thread starter Peter
  • Start date Start date
P

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?
 
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
 
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


.
Click to expand...
 
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)
 
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?
Click to expand...


.
Click to expand...
 
Back
Top