strange div by zero error

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
 
D

Douglas J. Steele

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.
 
Top