"Overflow"

[buggy2]

I am querying a table of 50,000 + rows. It contains a number of numeric (double) fields. I have created a query which does the following:

- select data for a particular day (averages 3500 rows)

- returns a values, taken from expr1: a/b, where a and b are values
in the table.

when I run the query I get an error, which simply states "Overflow". I know it relates to the division expression as I have calculated other values here with no problems.

Any ideas.

 

[Joe4]

You probably have some instances where b = 0, is blank, or is a text value, making your division bomb out. You will probably need to use and IIF statement in your calculation to check the valu eof b, i.e.

expr1: IIF(b<>0,a/b,0)

 

[buggy2]

thanks