HELP!!! with Access 2003 "overflow" dialog box.

  • Thread starter Todd A. Anderson
  • Start date
T

Todd A. Anderson

When I run the following query, everything is ok.

SELECT CN, count(*)*4
FROM CFUT
GROUP BY CFUT.CN;

However, when I add a WHERE clause to the statement that checks if the
MYFLOAT column is less than 0.05 and I try to run the query then access
pops up a dialog box whose title box says "Microsoft Office Access" and
whose
contents simply says "Overflow" with an OK button.

SELECT CN, count(*)*4
FROM CFUT
WHERE CFUT.MYFLOAT < 0.05
GROUP BY CFUT.CN;

Note, if I change the WHERE clause to look at an integer column then I do
not
get this problem so I suspect it may be floating point related.

Please help!!

Todd
 
Top