convert values from LBs to KGs

[Guest]

I am setting up a database and I want to know can I include the CONVERT
function from an Excel sheet in the database. How do I reference the location
of the data point (i.e. the cell address (D390) in the Excel sheet example
below) within the data table? Is it feasible to do this?

Conversion formula for lbs to kg in MS Excel

=CONVERT(D390,"lbm","kg")

 

[John Nurick]

Hi Tara,
Database tables are very different from spreadsheets, and thinking in
spreadsheet terms doesn't get you very far. If you've got a field containing
values in lb, you can display the kg equivalent by using a calculated field
in a query, like this, replacing XXX with the name of the field.

Kilos: [XXX] * 0.45359237

Or you can use an update query to replace the lb values with their kg
equivalents.

There are lots of useful conversion factors at
http://en.wikipedia.org/wiki/Conversion_of_units