Mar 26 2024 11:44 AM
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?
Mar 26 2024 11:58 AM
SolutionHi,
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
Mar 26 2024 12:08 PM
Mar 26 2024 11:58 AM
SolutionHi,
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