convert values from LBs to KGs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tara Keane - 27 May 2005 09:27 GMT

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")

Reply to this Message

John Nurick - 27 May 2005 17:49 GMT

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

>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
[quoted text clipped - 5 lines]
>
> =CONVERT(D390,"lbm","kg")

Reply to this Message