Invalid Argument/Division by Zero

R

Robert

I have a query that generates a very large recordset
(about 2.5 million records). I need to build a table from
a portion of this data.

When I try to create the whole table I get this error

"Invalid Argument"

When I try to filter the data and create a table I get

"Division by Zero"

I don't know what these errors mean.

PLEASE HELP!
 
L

Lynn Trapp

It means that some of the values in your query are the result of dividing by
zero, which is an undefined value. You will need to use the NZ() function to
change those values to zero.
 
Top