Try this --
Interest Payment: Format([Balance Due]*0.05+[Balance Due], "$0.00")

--
Build a little, test a little.


"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

--
Mike