Percentage Headaches

[tonygg]

Hi. I am trying to do something simple but just failing completely.

I have 2 currency amounts stored as doubles. One is total sales. The other is total commission paid. I am dividing commission paid (65.24) by the total sales (1983.54) to get the commission percent. However it just comes out with a random amount. I guess its because I am using doubles.



Please could someone let me know the trick to be able to either store the numbers differently to get % to work or create a % from them.

Thank you so much

Tony

[pbaldy]

Double should be fine. Can you post the db here?

[alansidman]

Where are you attempting this calculation? Form? Query?