asked on #Type! error
Experts,
Why would I get a #Type! and how can I get rid of it?
this is the formula I am using: =Nz([txtAmount],0)-Nz([txt
I thought NZ would take care of it but it doesnt. YOu can see some fields do not have the error and the ones that do there is a null.
thank you
![Capture.JPG]()
Why would I get a #Type! and how can I get rid of it?
this is the formula I am using: =Nz([txtAmount],0)-Nz([txt
I thought NZ would take care of it but it doesnt. YOu can see some fields do not have the error and the ones that do there is a null.
thank you
Microsoft Access
Last Comment
Dale Fye
ASKER
Hi John, thanks...didint seem to be the trick though. The fields are both currency if that matters.
txtSumPmts is like this:
=Format(DSum("Amount","qryPaymentsSum","LCID=" & [LetterOfCreditID] & ""),"Currency")
Amount is just simply [amount].
Letme know if you have another idea....thanks!
txtSumPmts is like this:
=Format(DSum("Amount","qryPaymentsSum","LCID=" & [LetterOfCreditID] & ""),"Currency")
Amount is just simply [amount].
Letme know if you have another idea....thanks!
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
nice! Worked perfectly. thank you much!
@pdvsa,
Just so you understand, the Format() function always returns a string. So if you are going to use that value in another computation, you would need to translate that back into a numeric value. I'm willing to bet that John's original response was really close. I would have recommended:
Just so you understand, the Format() function always returns a string. So if you are going to use that value in another computation, you would need to translate that back into a numeric value. I'm willing to bet that John's original response was really close. I would have recommended:
Val(Nz([txtAmount],0))-Val(Nz([txtSumPmts],0))
try converting the values to see if this fixes it
Open in new window
If this fails share a sample for all of us to take a look.