J
Judi
Hi, I'm using Access 2003 and XP.
I have a database that records many things, including the weight of chunks
of metal... most of the users of the database put in to total weight in
pounds, which is great, it offers a little more finnesse in measuring the
weight and recording said weights.
I will be adding one user very soon with his own form since he is in a
different division and uses all of the information from the main form and a
little bit more. This new guy is used to entering weight as Tons, not pounds
and I would like to accommodate that preference, but still have the data go
into the same cell in the table.
Can anyone tell me how to:
1) translate the tons into pounds automatically when he enters them
2) keep his view with tons in his form
3) show his weights as pounds in other forms
Basically, I have no power to make him start using pounds instead of tons,
and if the form is not easy enough, he either won't use it or won't use it
right, which defeats the purpose...
Many thanks to all who help on this site, and more specifically, those who
help me.
Please know that I'm still a beginner and need you to talk slowly and use
small words...
Thank you so much!!
I have a database that records many things, including the weight of chunks
of metal... most of the users of the database put in to total weight in
pounds, which is great, it offers a little more finnesse in measuring the
weight and recording said weights.
I will be adding one user very soon with his own form since he is in a
different division and uses all of the information from the main form and a
little bit more. This new guy is used to entering weight as Tons, not pounds
and I would like to accommodate that preference, but still have the data go
into the same cell in the table.
Can anyone tell me how to:
1) translate the tons into pounds automatically when he enters them
2) keep his view with tons in his form
3) show his weights as pounds in other forms
Basically, I have no power to make him start using pounds instead of tons,
and if the form is not easy enough, he either won't use it or won't use it
right, which defeats the purpose...
Many thanks to all who help on this site, and more specifically, those who
help me.
Please know that I'm still a beginner and need you to talk slowly and use
small words...
Thank you so much!!