MetDick

I need to calculate a commission value from a currency field called "amount". Over the first 2500 the commission is 15% with a minimum of 40. Over the next 2500 the commission is 10% Over the next 5000 the commission is 5% Over the next 190000 the commission is 1% Over the remaining amount the commission is 0,5 % with a maximum of 6775. I am stuck Help is rewarded with a LinkedIn endorsement or enternal friendship! Dick

@Vaughan This is not really what I need Vaughan. I am aware of this option I am using ODBC to get the field to MySQL What I need is: a text field that holds the number... but with a "point" as a decimal separator

Hello everybody I need some help with a calculation field. I have a currency field that holds a calculated value. The decimal separator is European: a comma. Because it is a calculated value the number of decimals are not always 2: It could be 1000,5 or 1000,52 or even 1000,5232198 My problem: i need to export the field to a MySQL table the format should then be: 1,000.00 (US currency, with two decimals) Can anyone help me with a calculation that: - sets the number of decimals to 2 - converts the comma to a point Great! Dick