how do I convert a number and save it as a field in a table?

[CK]

Hi, I'm hoping someone may be able to help me.
200+ people have filled out heights and weights on a questionnaire, which I
need to put into a table. They have entered their weights as either kg or
stones/lb and their heights as cm or ft/inches. Rather than manually
performing the conversions, is there a simple way that I can create the form
such that I can enter the value thay have written in either format, but have
it saved in metric format in the underlying table ?

Previous posts on this discussion group suggest creating a query, but as I'm
only going to enter the data once and not change it, surely it doesn't need a
separate query, which wouldn't store the final number anyway?

hope this is straightforward!
Regards
CK

 

[Klatuu]

The first trick is to know which scale they used to enter the information.
If you have an easy way to do that, then all that will be necessary is to use
the After Update event of the control they enter the information in run a
conversion routine.

The only one that is hard is converting miles per hour to furlongs per
fortnight

 

[KARL DEWEY]

The query would be an update query and it would replace the data and would
store the final number.
Converting kg or stones/lb may not be a problem. If the number is less than
a given value then it would be stones - over a value then lbs but where would
100 fall? It could be 100 lbs or 100 kg.
Converting cm or ft/inches will have the same problems. How will you enter
6' 2" in the field? You need two fields for that type entry.

 

[CK]

Thanks Klatuu and Karl for your help, what you have both said sounds logical
but I would be grateful if we can simplify it a bit.

Lets ignore the unhelpful feet and stones and instead simply use inches/cm
and lbs/kg.

On my data entry form is there a way to enter cm into one box OR inches
into another, but in the latter case convert it into cm for storage AND
display as if the value in inches had never existed?

Thanks again for your help
CK