SOLVED

Access Calculated Field - Query

Copper Contributor

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 Replies
best response confirmed by shubox56 (Copper Contributor)
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

BINGO! That resolved the issue. Thank you!
1 best response

Accepted Solutions
best response confirmed by shubox56 (Copper Contributor)
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

View solution in original post