Skip to Content
0
Former Member
Feb 21, 2011 at 05:15 PM

need to exclude 0 results

24 Views

I have an access database. I have a separate cross tab for every variable in the database. The answers to each variable can be 0,1,2,3,4,5.

0 is actually meant to be "missing". I need to totally exclude 0 from even being read in because the the crosstab is being used to show the % of responses that were 1,2,3,4,5 so we do not want 0 skewing the results.

So if question 1 has 400 respondants, and 10 of them give a 0(missing) for it, then the 1,2,3,4,5 results % will be based off a count of 390. So basically just need to exclude any 0 results showing up or being used in results for the crosstab.