View Single Post
  #1  
Old December 8th, 2009, 04:01 PM posted to microsoft.public.access.queries
mike
external usenet poster
 
Posts: 3,942
Default Calculated Query

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