#Error in output (need a handler)

Experts, how would I handle a #error output for some of the records? the below doesnt work since records still have #error: CurrAmount: IIf(IsNull([CurrAmt]),0,[CurrAmt]) thank you. Let m...

access

Ken_Sheridan
Sep 18, 2024
Rather than calling the IIf function you can call the Nz function to return a value in place of a Null:

CurrAmount:Nz(CurrAmt,0)

With currency values, however, it is usually appropriate to set the DefaultValue property of a column to zero in a table definition, or, in the case of a computed column, return a zero in a query's result table. Null is the absence of a value and semantically ambiguous, e.g. what would a Null at the CreditLimit column in a Customers table mean?

Ken_Sheridan

Brass Contributor

Sep 18, 2024

Rather than calling the IIf function you can call the Nz function to return a value in place of a Null:

CurrAmount:Nz(CurrAmt,0)

With currency values, however, it is usually appropriate to set the DefaultValue property of a column to zero in a table definition, or, in the case of a computed column, return a zero in a query's result table. Null is the absence of a value and semantically ambiguous, e.g. what would a Null at the CreditLimit column in a Customers table mean?

Tony2021

Steel Contributor

Sep 18, 2024

thank you. I had to take a different approach and once I did I could use your suggestion. It looks good now. Glad to get that done. thank you!

Forum Discussion

#Error in output (need a handler)