I have a query that looks at survey information and tallies how many people voted for in each of 5 answer categories (Highly Satisfied, Satisfied, Neutral, Unsatisfied and Highly Unsatisfied). Sometimes, depending on the question, there are no votes in that category, so only the categories that are voted for display. This makes each query inconsistent from the previous. Is there a way to have all of the possible answers display - even if no one voted? I dont think I could just add additional records to the underlying table, because I need to run some calcs on these values and that would skew the results.
Ultimately I have to create reports, so if it is easier to do this on the report side, please advise.
Thanks.
Vicky