How to convert from Metric Pound to Metric Kg.

[Jaap]

Dear forum,


Currently the quantities of all fish species stored in metric Pounds must be changed to Kilograms,
as an example I have dragged three fields, FishDate, Pike-perchand SperchPrice into a new Query.


I would like to ask you what is the best and most importantly safest way to do this, please?

Regards Jaap

[Welshgasman]

Calculation in a query.

[Micron]

The question I have is, do you really want to alter the numbers in the table? Then you'd need a calculated field in an Update query that either divides or multiplies the fields by 2. Usually it's best to leave original data alone and do the calculations in forms or reports (because you shouldn't be mucking about in tables or queries). That way you don't lose the original values should something go wrong with the process that would edit this data.

[Jaap]

Dear Micron, thanks for your reply,
I understand what you wrote.
The fisherman must then continue to convert to pounds because the buyer weighs his catches in kilograms.
Mistakes can also be made when converting kilograms to pounds.
The best thing is that the fisherman can immediately enter the Kilograms and the kilogram prices in his Access program for now and in the future.

Jaap

[Jaap]

I thought I would do the following
Delete all the Snoekbaars data, then Copy / Paste Convert Snoekbaars data in the field Snoekbaars?
Then the same with Sbaarsprijs?
I would like to know what you think of this, please?

[Micron]

No, not really. How is the data entered and into what? This doesn't make sense to me

The fisherman must then continue to convert to pounds because the buyer weighs his catches in kilograms.

If the fisherman is the first supplier in the chain and he/she is entering the catch weight and converting to pounds then what is the unit of measure before the conversion? I can't be kilograms otherwise there'd be no need for conversion. Perhaps it does not matter that I grasp what is going on.

If the entry is made by the fisherman and he/she uses data provided by the buyer. I might have a table field for the initial entry (maybe that is metric pounds?) and in the form for this table, fisherman enters the usual value. When he leaves the control on the form, another control (calculated and unbound) displays the weight conversion. So if he enters 6 as you have shown, the other form control (Converted Snoekbaars) shows a value of 3 for that record. There would be no need for adding more table fields or updating existing records.

[Jaap]

Thank you,

The fisherman still entered the weighs as metric pounds.

There would be no need for adding more table fields or updating existing records.

From now on, the fisherman would like to enter all fish species as metric kilograms and no longer as pounds.
If other people will also fill in later, filling in with Kilogram is the safest option.

I hope you can understand me?

Jaap

[Minty]

If this is going to be a one off change, that then means your new data is entered in Kilo's, (I have no idea what a metric pound is... I assume they are Imperial Pounds) I would create the two extra fields in your table as per your post #5.

Use your calculations to update the new fields to the correct new data.

Once you are satisfied everything is correct, take a back up , then take another backup.
Then rename the old fields with an x_ in front of them and rename the new fields to the old field names.

Change the forms to match the new units being referred to.

Everything should work as it did before, but with the new values in Kg.

[CJ_London]

confusion for me is there are 2.2lbs to a kilo (or to be more accurate 2.204622621848776lbs to a kilo) So not sure why using 2. I've never heard of a metric pound

[Jaap]

Sorry about the metric pound, I was afraid that there might be a difference with UK pounds,
it's just turning pounds into kilos, I hope this could be done with an update query,
if so, I would like to see an example of how I should do that, please.

[Welshgasman]

confusion for me is there are 2.2lbs to a kilo (or to be more accurate 2.204622621848776lbs to a kilo) So not sure why using 2. I've never heard of a metric pound

Alexa says a metric pound is half a kilogram? I'd never heard of it either.

[Welshgasman]

Take a backup first.
I would use a Select first to make sure you got it correct.

Then

UPDATE tblDaily SET tblDaily.CarbsCalc = Carbscalc/2, tblDaily.SugarCalc = SugarCalc*2
WHERE (((tblDaily.CarbsCalc)<>0));

replace with your field names. You should know which is which.

[CJ_London]

I googled 'metric pound' - didn't return anything, only the imperial pound

to answer the OP's question

if so, I would like to see an example of how I should do that, please.

use an update query

it will look something like this




Note I don't see why you use whole numbers for your weights, you may need to change your datatype to double - otherwise your fisherman may lose out

[Micron]

What do we expect/hope people will do when we post a term they don't understand (at least I do). First thing I did was Google 'metric pound'.

From now on, the fisherman would like to enter all fish species as metric kilograms and no longer as pounds.

Then I suspect the best approach is to ensure that the existing weight field(s) can accommodate the data type of the new values, then run an update query to change the values to kilos and enter only kilos going forward. As for 'metric' kilogram - is there any other kind? That's like saying 'imperial inch'?

EDIT -

I googled 'metric pound' - didn't return anything, only the imperial pound

That's odd because I got it right away in the results.

https://simple.wikipedia.org/wiki/Po...)#Metric_pound

[CJ_London]

That's odd because I got it right away in the results.

what can I say - It didn't come up for me - although having revisited and scrolled down further I found a converter than mentions the metric pound. Wikipedia did not come up

https://www.kylesconverter.com/mass/...ric)-to-pounds

However would appear that it is an informal weight, sometimes representing 500grams and sometime 480grams depending on where you are. Either way the OP needs a double because 47 metric pounds equates to 23.5 kilograms