Hi.

How to create a function to convert fraction to decimal ?
I am using an updatequery
UPDATE [table] SET [table].[decimalfield] = function fractionfield

Fractionfield is TEXT !
Decimalfield: Number, Precision = 5, Scale = 2, Decimal Places =2


1 1/4 to 1,25
1/2 to 0,50

Thanks!

Hi -

Take a look here (http://www.accessmonster.com/Uwe/Forum.aspx/access-forms/46536/Converting-a-fraction-to-decimal).

HTH - Bob

Thank you for help !!