Union Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to build a UNION query. It consists of 4 SELECT statements. If I
try everyone apart or I use any combination of 2 out of 4 SELECT statements,
they work. The problem is that when I use more than 2 SELECTstatements I get
the following message:
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data."
Does anyone know what should be the problem?
 
Did you try swapping out the SELECT statements for each combination? I'm
wondering if one of the fields referenced in one of the statements is a
too-small text field or a number field of a different data type (single,
long, double, etc.). Have you checked all of the fields you are attempting to
combine?
 
Thank you for your reply.
In fact, I tried swapping of the select statements, and I checked the fields
without success. Anymore clues.

Thanks.
 
Hmm, I think I recall that error message. You are copying the data into the
query window, correct? I think I've seen that message before when copying
into the SQL query view. Have you tried pasting your statements into Notepad,
selecting all of it and then pasting into the query window?

Also, are you using memo fields, by chance? As an alternative to the above,
you might try doing this query without any memo fields to see if you still
get this message. If you use the DISTINCT keyword, maybe exclude that for now.
 
Back
Top