|
| 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
December 8th, 2009, 03:01 PM
posted to microsoft.public.access.queries
|
|||
|
|||
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 | |
|
|
Threaded Mode