how to edit a table

[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

 

[John Spencer]

Post some examples of your data.

Do all the addresses have a post code at the end? Are they all the same length? etc.

 

[John Vinson]

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

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]