#Num! Error
From: Crown Royal (CrownRoyal_at_discussions.microsoft.com)
Date: 09/01/04
- Next message: Dwise: "Print a Tab instruction in "Code 3 of 9" bar code on an Access re."
- Previous message: fredg: "Re: Count"
- Next in thread: Allen Browne: "Re: #Num! Error"
- Reply: Allen Browne: "Re: #Num! Error"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 1 Sep 2004 09:49:09 -0700
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
- Next message: Dwise: "Print a Tab instruction in "Code 3 of 9" bar code on an Access re."
- Previous message: fredg: "Re: Count"
- Next in thread: Allen Browne: "Re: #Num! Error"
- Reply: Allen Browne: "Re: #Num! Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
