From: Maarkr on 27 May 2010 17:00
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