“Division by zero”

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gonzalo - 16 Apr 2008 20:53 GMT

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”

Reply to this Message

Jerry Whittle - 16 Apr 2008 20:59 GMT

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

Signature

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”

Reply to this Message

Klatuu - 16 Apr 2008 21:51 GMT

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 :(

Signature

Dave Hargis, Microsoft Access MVP

> Hours Earned: IIf([UHP] = 0, 0,Sum([Qty]/[UPH]))
>
[quoted text clipped - 3 lines]
> > Sum([Qty]/[UPH]) = 0 , write now I’m getting a message that says “Division by
> > zero”

Reply to this Message

Gonzalo - 17 Apr 2008 00:59 GMT

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.
>
[quoted text clipped - 9 lines]
> > > Sum([Qty]/[UPH]) = 0 , write now I’m getting a message that says “Division by
> > > zero”

Reply to this Message