Thank you all for helping me, everything is working fine now. :-)
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
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Dear Welshgasman,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
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.