"Overflow" error in an Access 20003 query

[Harry]

When I run a select query that links two tables that should result in 83,000
records I get an "Overflow" error message. No other information about the
error is available. If I restrict the result to under 10,000 records with a
parameter query I do not get the error, but I will get the same prompt twice
instead of once as I expect. Which normally would be fine except my boss
wants a "frendlier" interface and I need to start with a complete data set.
This is all I Know
New Operating system, XP
New computer
New Access 2003
Same Dataset
All fields in both tables are correct
I am not dividing by 0, there is only 1 math function and it is multification
And I have never seen an "Overflow" error in any Access application I have
ever designed.

I have read several posts on "Overflow" but none of them seam to apply. Does
anyone know of any reason that I can not query on 83,000 records or why this
error occurs?

 

[Jason Lepack]

Ususally overflow is due to a value being too big for the variable.
I'm guessing (really guessing...) that your multiplication is coming
out with a result greater than 32,767 and that you're using an
integer, or your result is greater than 2,147,483,642 and you're using
a long integer.

But taht's just a guess. If you're still having problems then post
the SQL of the query in question, a list of the fields in the table
and expected output of the query and we'll be able to tell you what's
causing the problem then.

Cheers,
Jason Lepack

 

[Harry]

Thank you Jason, you got me on the right track. I changed all numerical
fields to Double and the query will now run. I also noticed after the query
ran that there 11, 000 records with null values in the numerical fields. Does
this also create a problem?

 

[Jason Lepack]

Nope. Null multiplied by anything is Null.

Thank you Jason, you got me on the right track. I changed all numerical
fields to Double and the query will now run. I also noticed after the query
ran that there 11, 000 records with null values in the numerical fields. Does
this also create a problem?








- Show quoted text -