Overflow (Error when running a query)

  • Thread starter Thread starter WaterBrook
  • Start date Start date
W

WaterBrook

I have a very basic query where I'm pulling data from a
huge table, and calculating a field based on two others in
the query, it summarizes the data perfectly. When I try
to add criteria in the query for the calculated field
(i.e. <1.5) the query fails and gives me an error message
that simply says "Overflow".

Does anyone know what the error message "Overflow" means,
and does anyone know how to work around it?
 
It is probably a Stack Overflow. It is a portion of memory used by a program
for temporary storage of data. I have seen this sort of problem fixed by
getting the most recent service pack for Jet. For Jet 4 (Access 2000 and
newer) it should be available at http://windowsupadte.microsoft.com. You can
also find it here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114&Product=acc2002
and for Jet 3.51 (Access 97)
http://support.microsoft.com/default.aspx?scid=kb;en-us;172733&Product=acc97
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overflow error on calculate field in query - Help Please 1
Numeric Field Overflow Error 5
Numeric Field Overflow 1
Overflow 1
"Overflow" message in UNION query 4
Access Overflow error 3
Limit on Number of Fields 3
Numeric Field Overflow when appending date - how to convert it to text 1

Back
Top