How to convert from Metric Pound to Metric Kg.

[Jaap]

I like to thank you all,



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

Before I will do anything, can you confirm if the changes I've made are correct, please?

[Jaap]

I think this is what you mean to tell me.

I've made some experiments with Update Query, when using Field Size Double: it works fine, when using Long Integer: in some cases wrong calculations appears.

Table setting

[Jaap]

Thank you all for helping me, everything is working fine now. :-)

[Welshgasman]

I think this is what you mean to tell me.

I've made some experiments with Update Query, when using Field Size Double: it works fine, when using Long Integer: in some cases wrong calculations appears.

Table setting

it is called Integer for a reason?
The Long just means you can hold larger integer numbers in it, as opposed to the Integer type.

https://learn.microsoft.com/en-us/of...a-type-summary

[Jaap]

it is called Integer for a reason?
The Long just means you can hold larger integer numbers in it, as opposed to the Integer type.

https://learn.microsoft.com/en-us/of...a-type-summary

Dear Welshgasman,

Thank you for helping me, I've learne from Micron I've pasted undernee:

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.

I was trying to drive everyone crazy with my nervous behavior, apologies for that.

While working in a Copy File, and with the Update Query, I saw that there were indeed errors in the results.
With the settings as in the Appendix, I see that the results are fortunately OK.



Regards Jaap.