“Division by zeroâ€

[Gonzalo]

I have the following Expression in a query, Hours earned: Sum([Qty]/[UPH])

I want to add an IF statement that says if the value in UPH is 0 then
Sum([Qty]/[UPH]) = 0 , write now I’m getting a message that says “Division by
zeroâ€

 

[Jerry Whittle]

Hours Earned: IIf([UHP] = 0, 0,Sum([Qty]/[UPH]))

 

[Klatuu]

In a Totals query, I think it would have to be styled a bit different, Jerry.

Hours Earned: Sum(IIf([UHP] = 0, 0,[Qty]/[UPH])

Are you and I the only ones not at the Summit
--
Dave Hargis, Microsoft Access MVP

Hours Earned: IIf([UHP] = 0, 0,Sum([Qty]/[UPH]))
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have the following Expression in a query, Hours earned: Sum([Qty]/[UPH])

I want to add an IF statement that says if the value in UPH is 0 then
Sum([Qty]/[UPH]) = 0 , write now I’m getting a message that says “Division by
zeroâ€

 

[Gonzalo]

You are correct, the way you styled it works, thank you.

In a Totals query, I think it would have to be styled a bit different, Jerry.

Hours Earned: Sum(IIf([UHP] = 0, 0,[Qty]/[UPH])

Are you and I the only ones not at the Summit
--
Dave Hargis, Microsoft Access MVP

Hours Earned: IIf([UHP] = 0, 0,Sum([Qty]/[UPH]))
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have the following Expression in a query, Hours earned: Sum([Qty]/[UPH])

I want to add an IF statement that says if the value in UPH is 0 then
Sum([Qty]/[UPH]) = 0 , write now I’m getting a message that says “Division by
zeroâ€