Forum Discussion
Access Calculated Field - Query
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?
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
2 Replies
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- BINGO! That resolved the issue. Thank you!
