Forum Discussion
Solved
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_Inte...
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
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!
