| | |
|
|
|
** Help with queries or reports |
|---|
| message from GabrielG on 8 May 2004 |
Hello everyone ,
I have a little issue to setup a database. I created a table with
approximately 20 columns. The columns have an entry of Yes or no base on a
questionnaire from survey. What can I do to get a result of my table I would
like to know how many "Yes" and "no" I have. I don't know how to add them or
get this information.
Thanks in advance
GABRIEL
|
| Larry Linson replied to GabrielG on 8 May 2004 |
You want a sum for each column? Or do you want an overall total of all the
Yeses in all the columns and all the Nos in all the columns?
IIF([C1]<>True, 1, 0). Include those in the report (they do not have to be
visible) and sum each in the Footer.
Larry Linson
Microsoft Access MVP
"GabrielG" <GabrielG@computechmaster.com> wrote in message
news:eYfcOBXNEHA.2976@TK2MSFTNGP10.phx.gbl...
|
| GabrielG replied to Larry Linson on 9 May 2004 |
Thanks for the information. However I am novice on this area and I don't
know exactly where I need to type these commands. Please advised. Thanks
again
|
|
Archived message: ** Help with queries or reports (Microsoft Access)
