Query Formula (stones and pounds to kg's)

  • Thread starter Thread starter Karren Lorr
  • Start date Start date
K

Karren Lorr

I have a table with 2 weight fields, stones and pounds.
Is there a formula that I could use to convert this into a single kg field.

I would be doing this in a query

There are many answers on google but they seem all to be for excel.

Thank you
 
I have a table with 2 weight fields, stones and pounds.
Is there a formula that I could use to convert this into a single kg field.

I would be doing this in a query

There are many answers on google but they seem all to be for excel.

Thank you
Click to expand...

Do you want all three fields? That would be bad design, since they're
redundant (three ways of depicting the same fact). Does each record have only
one of stones or pounds filled in? If both, what would you do if you had
numbers that don't agree?

A table should not have any calculated fields in it; you can run an update
query to update the kg field to the correct value, on a one time only basis:
create a query based on the table, change it to an Update query, and update kg
to

IIF(Not IsNull([pounds]), 2.2*[pounds], IIF(Not IsNull([stones]),
6.35*[stones], Null))
 
Back
Top