Calculated Query
You can try
CCur([Balance Due] * 1.05)
but make sure that Balance Due is never null before doing that.
IIF([Balance Due] is Not Null,CCur([Balance Due] * 1.05),[Balance Due])
OR use the nz function to return zero for nulls
CCur(Nz([Balance Due],0) * 1.05)
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Mike wrote:
I have a query with a field called Balance Due. I need to add 5% to the
Balance Due which I know how to write the expression
Interest Payment: [Balance Due]*0.05+[Balance Due]
BUT, when the query runs, there is no $ sign next to the result. The Balance
Due in the table is defined as currency.
How do I get a $ sign to appear next to Interest Payment?
Thank you
|