Access Calculated Field - Query

[shubox56]

I'm trying to sum 2 fields in a query (each row), the query runs but doesn't display the calculated value.

Query fields to sum:

CR_Interest_BAL

CR_Interest_BAL2

Tried this:

Expr1: [CR_Interest_BAL]+[CR_Interest_BAL2]

Expr1: Sum([CR_Interest_BAL]+[CR_Interest_BAL2])

Neither produced a result.  What am I doing wrong?

[#2 · Accepted solution]

Hi,

Are there always values in both fields? If one of them is empty or could be empty then try to use nz():

nz([CR_Interest_BAL])+nz([CR_Interest_BAL2])

Servus
Karl
****************
Access DevCon - online conference April 18+19
Access Forever
Access News
Access-Entwickler-Konferenz AEK

[#3]

BINGO! That resolved the issue. Thank you!