Changing numbers in a column

  • Thread starter Thread starter Amanda
  • Start date Start date
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?
 
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.
 
Back
Top