Lazy Query Ignores Data

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?
 
J

John Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Summary 1
to view data of a customer from union query 3
Getting data from the form to the tables 8
Report Query Works 2nd Time, But Not 1st 14
Query is too complex 5
Access Report Incorrectly Summing Grouped Data 1
Excel.QueryTable ignores some data types? 0

Top