Missing Data in Union Query

M

mvagnier

I'm combining responses from two different surveys. The two select queries I
specify in the union query work as expected when individually executed. The
union seems to drop data for a series of questions. If we can make the
assumption I have listed the same number of fields in each select and the
order and data types are the same, I'm trying to figure out what is going
wrong in combining the data sets. I'm happy to post the SQL, but to try and
keep it simple, this might provide some info:

SurveyA has Q.16a-g (seven questions), and SurveyB has Q.16a-h (eight
questions). The SELECT for SurveyA specifies seven fields for the answers,
followed by eight more fields assigned a null. Likewise, SurveyB specifies
seven null-assigned fields (same names as from SurveyA), followed by eight
fields for the survey responses.

For records from SurveyA, the UNION displays seven data-filled fields for
the answers from SurveyA followed by eight empty fields (then continues with
the remainder of the record), but for records from SurveyB, I get 15 empty
fields followed by the continuance of the record.

The UNION query specifies SurveyA fields first, then SurveyB fields (if this
matters.)

Any help will be much appreciated - Thanks in advance!

Mike
 
M

mvagnier

Jerry, I know you've heard this before, but "YOU ARE THE MAN!!"

I've been reading about the use of the "ALL" modifier, but it didn't seem
relevant (or required) for my situation. Looks like I was wrong (AGAIN!!)

Thank you very much,
Mike
 

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

Union query 5
Converting check box data into useable narrative 11
SUM in a UNION query 2
Union Query 1
Union Query 2
Duplicates in union query 3
Union Query - Group & Sum 1
Union Query 2

Top