If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query Formula (stones and pounds to kg's)
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 |
#2
|
|||
|
|||
Query Formula (stones and pounds to kg's)
On Thu, 27 May 2010 14:37:55 -0700, Karren Lorr
wrote: 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 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)) -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|