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.
 

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

Invalid Argument when running a Make Table Query 3
Division by zero problem 13
Invalid argument 2
Invalid Argument 5
Division by Zero Error 1
Invalide Argument 2
Division by zero when exporting to excel 5
invalid argument - access 2003 2

Back
Top