I am trying to build a query based on a table that has 226 fields. Each field (with the exception of the autonumber) is a question that can is answered: "Never/No", "Rarely", "Mostly", "Always/Yes" or "Not Obsv". I am trying to count the number of each answer type per question. IE question Number 1 had:
and so on all the way to question 226.
I built my query to have two fields per quesiton. The first field is a "Group By" and the second one is a "count". However, in doing this some instances are duped even though it actually all adds up:
Try running an update query to make sure that all values are infact the same. THere may also be some type anomoly with the data. You may want to try creating a duplicate of the table and re-running the query to see if you get the same results.
One other thing. There has to be a better way to store your data than by a 226 field table. You may want to do some reading on normalization or 3NF. This may make your gathering of information a little easier to summarize your information.