Lazy Query Ignores Data

  • Thread starter Thread starter Jacque Crocker
  • Start date Start date
J

Jacque Crocker

I input about 50 answers from each of 500+ Microsoft-
designed surveys using a form, and they're all in a table,
but the Union query I've been able to create in SQL only
processes about two-fifths of the data. BTW, this is my
first Access project.

This query is counting and summing the number of reponses
in each of four categories for each question.

Is there some reason it stops partway through the table?
Is there any way I can change this situation?
 
Is there some reason it stops partway through the table?
Is there any way I can change this situation?
Click to expand...

Please post the SQL of the query, and if it isn't clear from the SQL
the structure of the relevant tables. It's awfully hard to tell what's
wrong without knowing what's going on.
 
Back
Top