Calculated Query
I rarely care what the value looks like (formatting) in the query. I leave
the formatting for the form or report controls. Typically if you format a
number in the query, it becomes a string/text value so you lose the
capability of summing in your report or form.
--
Duane Hookom
Microsoft Access MVP
"KARL DEWEY" wrote:
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
|