Convert between kilograms & pounds

[wrangler_0002004]

Hi,
Can anyone help me to convert kilograms to pounds in Access 2010.



Thanks,

[Bob Fitz]

KgsValue/2.20462
should be fairly accurate

[wrangler_0002004]

Thanks, but how to put it in Access?

[Bob Fitz]

Where do you need it. What are you trying to do.

[wrangler_0002004]

I have two Fields one is for weight in kilograms and the second Field is for Pounds, what I am trying to do is when I enter the weight in the first Field in kilograms it automatically convert it to Pounds in the second Field.

[Bob Fitz]

You only need one field in the table for weight. If you store the Kgs weight in the table then the Pounds should be be calculated as and when required because the pounds is a calculated value and calculated values like this should not be saved.
If you need to see the pounds in a form you should have a control bound to the kgs field. The control that displays the pounds value should have an expression as its control source. Something like:
=[NameOfKgsControl]/2.20462

[wrangler_0002004]

Thanks a lot