union query overflow

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

My union query won't run, all I get is the
message "Overflow". What's that about?
 
Dear Adam:

Not a lot to go on. I suggest you break the query into separate
non-UNION SELECT queries and try each one. I think you'll find one or
more of them has this problem. Possibly you have some math that's
doing this in a calculated column. Remove calculated columns one at a
time to see which one it is. Replace the offending calculated column
with a set of columns that display the values used in the calculation.
Next, you'll need to look at these to see which set of values is
incalculable. Let us know what you find if you still need help.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
You must log in or register to reply here.

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

"Overflow" message in UNION query 4
Overflow Error Message 2
Limit on Number of Fields 3
Query is too complex 5
Union Query and Field Alias 7
UNION QUERY 2
Union Query - Group & Sum 1
Overflow Error On Union QUery 2

Back
Top