I am getting an OVERFLOW message when I try to run a query

[Guest]

I have 2 vitually identical queries, on one the criteria is set to "F"
(female) the other "M" (male).
the female query runs OK, but the male runs a while then an errormessage
comes up showing "Overflow".
The only difference as far as the amout of data processed is there are more
males than females.

 

[Brian]

I have 2 vitually identical queries, on one the criteria is set to "F"
(female) the other "M" (male).
the female query runs OK, but the male runs a while then an errormessage
comes up showing "Overflow".
The only difference as far as the amout of data processed is there are more
males than females.

Please post the SQL

 

[Guest]

hi,
I usually get the overflow message when i have a data type
wrong. an integer when it should be a long.

 

[Guest]

I don't think that's it as it works ok with one not the other

 

[Brian]

I don't think that's it as it works ok with one not the other

It could very well be that. If you have some kind of calculation going on,
it could be that one of your males has something big that none of the
females has (a NUMBER, I'm talking about NUMBERS ) which is causing the
overflow. That's why I wanted to see the SQL, it will probably be quite
clear where there is scope for overflows.

 

[Guest]

I have gone back to this query and had a good look at it after what you said
and I found that one part of the query was causing this problem, after
removing it, it worked a treat, I have now set up another query to do the
part I took out and I now get what I want.

thanks for your help

Terry