#Num! Error

I have a report in which one part calculates the results from one field
divided by another. When there is a number in the divisor, everthing is fine,
but when the divisor is zero (the dividend is always zero at that point as
well), I get the Num error. The control source for this control is:
=DSum("[TransientRackRate]","[qryRoomsDaily]")/[RackTodayAnalysis]
I have tried to add an Iff to it, but I guess "And" is not what I need. Thx
for any help

Eric

Use IIf() to test for zero in the divisor:
=IIf([RackTodayAnalysis] = 0, 0,
DSum("[TransientRackRate]","[qryRoomsDaily]")/[RackTodayAnalysis])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Crown Royal" wrote in message
...
I have a report in which one part calculates the results from one field
divided by another. When there is a number in the divisor, everthing is
fine,
but when the divisor is zero (the dividend is always zero at that point as
well), I get the Num error. The control source for this control is:
=DSum("[TransientRackRate]","[qryRoomsDaily]")/[RackTodayAnalysis]
I have tried to add an Iff to it, but I guess "And" is not what I need.
Thx
for any help

Eric