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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Create a Phone Book using MailMerge in word 2007 0
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Exporting Access Report to Excel 3
Excel Subtracting multiple columns from another column 3
Average time from date time column? 3
Like numbers in a field 3
autonumbering question 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top