"Overflow" error on SELECT query

  • Thread starter Thread starter Kanga
  • Start date Start date
K

Kanga

Hi,

I have created a database made up of just a few tables.
I then created SELECT queries based on another SELECT query which refers to
a third one.
So it looks like this
Query A: SELECT... FROM ....
Query B: SELECT... FROM Query A
Query C: SELECT... FROM Query B
Query D: SELECT... FROM Query C
The last query generates the data and a couple of seconds later I get an
error which says "Overflow".
I assume this is due to the fact that the SELECT query I'm running is made
of multiple subqueries. Is their such limitation?

Thanks in advance,
 
Are you doing any calculations in any of the queries?

That's really the only reason I can think of why you'd get an Overflow
error: you're adding together values and the total is larger than the data
type can hold.
 
Hi Doug,

Thanks for your quick answer.
I do indeed perform calculations such as SUM or / or *.
The fields that I'm doing this from are set to Double.

Should I change that to something else?

Thanks in advance,
 
Also I should mention that this is happening on my last query which is simply
doing a union of two queries. The queries run fine separately. That is what I
will do for now but I'd be quite curious to understand what is causing this.

Thanks!
 
That makes no sense to me!

Does it happen just running the query, or are you using the query in some
way (as a recordset for a form or report, for instance)?
 
Kanga said:
Hi Doug,

Thanks for your quick answer.
I do indeed perform calculations such as SUM or / or *.
The fields that I'm doing this from are set to Double.

Should I change that to something else?

Thanks in advance,
Click to expand...
 
Back
Top