strange div by zero error

  • Thread starter Thread starter njack217
  • Start date Start date
N

njack217

ok here goes. when running this querry on data that is formated as
double, and includes positive and negative numbers with 3-4 decimal
places i get a divide by zero error. can anyone recreate this or have
any suggestions on how to work around it?

SELECT Sum(IIf([ext_ppv]<0,[ext_ppv],"0")) AS goodppv
FROM cap5010F;

Thanks,
statikf
 
I don't know whether this is related to your problem, but there shouldn't be
quotes around the 0 in the IIf statement: you want a number, not text.
 

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

#DIV error 5
Aggregate Function Error 0
Formatting currency 4
Dividing by Zero in Access Reports 14
divide by zero error 5
Show zero and not error when division by zero 5
aauugghhh...#div/o problems & various average formula problems 5
Division by Zero Error 1

Back
Top