E
Erik
Hi
I have two queries, lets call them Query A and Query B, which run fine when
they are executed in isolation. They are quite complex with lots of
calculations and functions embedded in them, but they both run ok.
Now, I need to do a UNION to combine them. Naturally, all the columns are
the same.
However, after a while of crunching the numbers, Access comes up with the
message "Overflow "
Does anyone know why it should stumble, given the two queries, in isolation,
do actually run ok?
Many thanks for any thoughts!
Erik
I have two queries, lets call them Query A and Query B, which run fine when
they are executed in isolation. They are quite complex with lots of
calculations and functions embedded in them, but they both run ok.
Now, I need to do a UNION to combine them. Naturally, all the columns are
the same.
However, after a while of crunching the numbers, Access comes up with the
message "Overflow "
Does anyone know why it should stumble, given the two queries, in isolation,
do actually run ok?
Many thanks for any thoughts!
Erik