Divide by Zero error (#Error) in Access SQL statement

[Waxaholic]

I am getting a #Error result of an Access SQL statement. Is there some code i can use to default to a specific value, say "0", when this happens? Something to wrap the SQL in when this divide by zero error occurs and output the value "0" to the cell.

Thanks,

Brian

 

[jebry]

Hi Brian!

Say you have x/y, you can use this statement:

IIf(y=0, 0, x/y)

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Waxaholic]

Works like a charm. Thanks a bunch.

Brian