D
Doc Rock
I'm getting a #Error when I try to print the result of a query.
Sometimes the result ([paytype]) is "" and sometimes "D". I'm using
=IIf(IsNull([paytype]),"ch",[paytype])
but this isn't getting the results I want. Paytype is a string that is
set for Space$(0) as the default. Is there something other than IsNull
that would work? I have tried Nz, but that isn't correct, either.
Thanks
Doc Rock
Sometimes the result ([paytype]) is "" and sometimes "D". I'm using
=IIf(IsNull([paytype]),"ch",[paytype])
but this isn't getting the results I want. Paytype is a string that is
set for Space$(0) as the default. Is there something other than IsNull
that would work? I have tried Nz, but that isn't correct, either.
Thanks
Doc Rock