ACCESS METRIC CONVERSION

[netmog]

Hello All,

I have a database where I want to convert the data from several columns from English (in, ft) to metric (CM, M) units. Any ideas how to do this using a query or simple function? There are about 6500 lines of data to convert.

Thanks for your help,

Jason in California

 

[giacomo]

If your data is in a numeric format you could create a function like the one below that will do the conversion.

Public Function ConversionCalc(unit As Double, conversion As Integer) As Double
Select Case conversion
Case 1 ' Inches to Centimeters
ConversionCalc = unit * 2.54
Case 2 ' Feet to Meters
ConversionCalc = unit * 0.3048
Case 3 ' Centimeters to Inches
ConversionCalc = unit * 0.393700787
Case 4 ' Meters to Feet
ConversionCalc = unit * 3.2808399
End Select
End Function

 

[netmog]

Thanks! I'll give this a try..

Jason