Formular, Function, or Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one column that contains three numbers, a space, and a sentence. I
need to remove, delete (whatever the term) the first three numbers and space
OR move the sentence to another collumn. I need this action to repeat it's
self till it reaches a blank row (400 rows). Anyone who could whip out a
formular, function, or macro that would do this would be most appreciated.
Golden Girl
 
Golden,

This is a job for an Update Query. First step is to make sure you have
a backup copy of your table/database. Then, make a query based on your
table, and add the field in question to the query design grid. Make it
an Update Query (Select Update from the Query menu), and then in the
Update To row of the grid, put the equivalent of...
Mid([NameOfYourField],5)
.... and in the Criteria row, put...
Is Not Null

Run the query (click the button on the toolbar with the red [!] icon).
 
Back
Top