I have a Database that has multiple fees billed to a Client. One of the fees is a simple interest rate. It is based on the equation (.06/365)X(Total)X(number or days)
Any how to get a real dollar amount I had to use the format $0\.00.
Now I am at a point where I have to add all the Dollar amounts up and combine with all other fees.
The problem is with the above Format Access thinks $.08 = $8.00 Even though it displays .08.
When you focus on the feild that this format is in it changes to the $8.00 and lost focus goes back to $.08
If anyone has any ideas let me know
Thanks Kenny
Any how to get a real dollar amount I had to use the format $0\.00.
Now I am at a point where I have to add all the Dollar amounts up and combine with all other fees.
The problem is with the above Format Access thinks $.08 = $8.00 Even though it displays .08.
When you focus on the feild that this format is in it changes to the $8.00 and lost focus goes back to $.08
If anyone has any ideas let me know
Thanks Kenny
