Changing numbers in a column

A

Amanda

If I have a column of numbers and the numbers are 426000, how do change the
whole columns numbers so that they are 426, without changing the numbers one
by one?
 
J

Jerry Whittle

Use an update query and put something like below in the Update To for the
column in question:

[FieldName] / 1000

Make a backup or two of your database first and test this before making a
mess of production data.
 
Top