how to edit a table

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

Guest

please could someone tell me how to edit a table especially how to extract a
wrongly placed data from one column and place place it into the right column.
e.g: how to remove postcodes that were wrongly placed in an address column
and put them in their postcode column.

stay blessed
 
Post some examples of your data.

Do all the addresses have a post code at the end? Are they all the same length? etc.
 
please could someone tell me how to edit a table especially how to extract a
wrongly placed data from one column and place place it into the right column.
e.g: how to remove postcodes that were wrongly placed in an address column
and put them in their postcode column.

stay blessed
Click to expand...

The short answer is "with an Update query".

The specific details of that query will very much depend on the nature
of the data. It may be rather tricky to identify which alphanumeric
characters in an address column are in fact postcodes - is this
Canadian postcodes (at least they're all the same length), British
(ouch), or something else?


John W. Vinson[MVP]
 
Back
Top