[AccessD] Converting Imperial measures

Gustav Brock gustav at cactus.dk
Fri Feb 16 08:59:13 CST 2018


Hi all

Good examples for usage of Eval are rare, but here is one - a one-liner for converting Imperial feet-inch measures (string) to decimal feet (double):

DecimalFeet = Eval(Replace(Replace(Replace([Measurement], """", ""), "'", "*12 "), " ", "+")) / 12

It will accept expressions like:

6'
7"
7 3/4"
6'7"
6' 7"
6'  5 3/16"

/gustav


More information about the AccessD mailing list