From: Maarkr on
not perfectly clear but can't you just add the two converted values?
[Kg] field source
=[stone]* 6.35 + [Lbs] * 2.2

"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