Filtering information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built a database to input survey information. What I want to do is
set up a chart that shows how many Yes and No answers were recieved. After
that, I want to set up a chart actually breaking it down to each question.
I'm sure this is easy, but I have never used Access before yesterday and was
able to figure out the database, but deadline is nearing.

thanks
 
As to setting up the chart, I don't have enough info to help; however,
getting the counts you want into a select query by question is pretty simple.
You need 3 columns. The Question, a calculated field for Yes, and a
calculated field for No ( I am assuming the answer is a Yes/No - True/False
data type. If not, chage the comparison in the IIf statements to get the
results you want.

In the Question Column, just enter the field name of the question.
In the Yes column Yes: IIf([Answer] = -1, 1, 0)
In the No column No: IIf([Answer] = 0, 1, 0)
Sort the query by Question
Make it a Totals query
Use Group By for the question and Sum for the two answer columns. It will
return each question with the number of Yes and No answers for each.

Now you can use this query to base your chart on.
 
Back
Top