Invalid Argument/Division by Zero

  • Thread starter Thread starter Robert
  • Start date Start date
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!
 
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.
 
Back
Top