Yes/No

[taft71]

I have set up several YES/NO fields and when they are checked off I would
like to add them up. How is this done?

 

[MGFoster]

I have set up several YES/NO fields and when they are checked off I would
like to add them up. How is this done?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Some examples:

SELECT Abs(Sum([yes/no])) As YesAnswers
FROM ...

or

SELECT Abs(Sum([yes/no])) As YesAnswers,
Abs(Sum([yes/no]=0)) As NoAnswers
FROM ...

or

SELECT Count(*) As YesAnswers
FROM table_name
WHERE [Yes/No] = True

and

SELECT Count(*) As NoAnswers
FROM table_name
WHERE [Yes/No] = False

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQjOTcYechKqOuFEgEQKKlgCgxR3a9Gl8HuyhXpCMzsrthfg28acAoN8e
3/tPAE89uqExwJ3hpRwr9VIO
=opkr
-----END PGP SIGNATURE-----