Problematic Percents!

msoffice , access , vba India
  • 11 years ago
    Hello Friends. I am Prabha Karan from Thanjavur (South India). Currently I am working in a small Retail tool using access which mostly deals with the items having MRP and also a default tax percentage for that product. In our country (India) a new kind of tax called VAT (Value Added Tax) has been introduced. Most of the Commodities have 4% as the default VAT percent and some have 12% and some don’t have VAT Tax. I assumed the number data type to store the default percentage of an item and tried to format as a percentage. Here the problem came. Let’s Assume… Item Table Structure: Id : Auto number Name : String MRP : Currency VAT : Number (Formatted as Percentage) Item Table Data: Id Name MRP VAT 1 Item1 10.00 4 2 Item2 15.00 12 3 Item3 25.00 (Null) Query1 Structure: Column1 : Item Name Column2 : Quantity Column3 : (MRP x Quantity) + (MRP*VAT) Expected Query1 Result: Column1 Column2 Column3 Item1 2 28 Actual Query1 Result: Column1 Column2 Column3 Item1 2 60 Why this happen? How to overcome this? I also tried to give the VAT percent data in decimals i.e. giving as .4 or .12 but I didn’t accept it. Why? Thanks in advance.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Debuggers don't remove bugs. They only show them in slow motion.”