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.
Last edited by Micron; 12-12-2023 at 08:40 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.