Creating a report from a crosstab query

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

Guest

I have a table to collect data from a survey that has the responses set up as
option groups so that 0 = No Response, 1 = Exceeded Expectations, 2 = Met
Expectations, and 3 = Below Expectations. I have set up a crosstab query for
each question on the survey to tabulate the responses, and I want to set up a
report for each crosstab query. The problem is that not all the values for
each question are currently represented in the table (the surveys are only
just starting to come in). Is there any way to construct a crosstab query or
report that will include all possible values whether or not someone chose
them (e.g., if there are no records now in the table where "Overall
Experience" = 3, I still want 3 to show up on the report with a count of
zero). Is that possible, or will I have to wait until all the data is in
before I construct the reports?
 
Use the property column heading ie (no reponse,..) in the query to force the
query to output the columns you want.

HTH
Martin
 
Back
Top