Function to convert fraction (text) to decimal

[Clas]

Hi.

How to create a function to convert fraction to decimal ?
I am using an updatequery
UPDATE

SET

.[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!

 

[raskew]

Hi -

Take a look here.

HTH - Bob

 

[Clas]

Thank you for help !!