"Overflow" error on SELECT query

[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,

 

[Douglas J. Steele]

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.

 

[Kanga]

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,

 

[Kanga]

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!

 

[Douglas J. Steele]

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

 

[Howard Burgman]

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,