IsNumeric problem (I think)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use a control with the following control source to get a net due amount:

NetDue=Nz([QuotedAmount])-Nz([Coupon])-Nz([discamount])+Nz([PriceAdjustment])-Nz([CRAppliedToDate])-Nz([RecToDate])+Nz([Gratuity])-Nz([AmtDirectCG])+Nz([CGARTipTotal])

Note that [RecToDate] from above is also a control on the form with the
following control source:

RecToDate=IIf(IsNumeric(ARApplied.Form!SumOfRecAmount),ARApplied.Form!SumOfRecAmount,0)


My problem: If there is actually receipt to date, then NetDue is blank; if
there is no actual receipt to date then NetDue calculates fine. What can the
problem be?

Thanks in advance,
Chrissy
 
If there is a "receipt to date", does that mean that there is a value for
the [RecToDate] control? It is a bit hard to relate your different
words/names to what you posted.

--

Ken Snell
<MS ACCESS MVP>

chrissy said:
I use a control with the following control source to get a net due amount:

NetDue=Nz([QuotedAmount])-Nz([Coupon])-Nz([discamount])+Nz([PriceAdjustment]
)-Nz([CRAppliedToDate])-Nz([RecToDate])+Nz([Gratuity])-Nz([AmtDirectCG])+Nz(
[CGARTipTotal])

Note that [RecToDate] from above is also a control on the form with the
following control source:

RecToDate=IIf(IsNumeric(ARApplied.Form!SumOfRecAmount),ARApplied.Form!SumOfR
ecAmount,0)


My problem: If there is actually receipt to date, then NetDue is blank; if
there is no actual receipt to date then NetDue calculates fine. What can the
problem be?

Thanks in advance,
Chrissy
Click to expand...
 
Back
Top