If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|