** Help with queries or reports

  • Thread starter Thread starter GabrielG
  • Start date Start date
G

GabrielG

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

Create a query with two calculated columns for each of the existing columns,
for example for Column C1, add C1Yes: IIF([C1]=True, 1,0) and C1No:
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
 
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


--
GABRIEL
Larry Linson said:
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?

Create a query with two calculated columns for each of the existing columns,
for example for Column C1, add C1Yes: IIF([C1]=True, 1,0) and C1No:
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 said:
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
Click to expand...
them
Click to expand...
 
Back
Top