Copy data from one column to another

  • Thread starter mlthomas007 via AccessMonster.com
  • Start date
M

mlthomas007 via AccessMonster.com

Hi,

We have a database that is pretty populated and the client wants us to add
data from one column into another. We were looking for a quick cut and paste
method where we can select multiple fields and copy i.e. Excel but we can't
seem to find that option. We can only select one field at a time.

Thanks.
 
A

Arvin Meyer [MVP]

In Access, you can select contiguous fields. Move them to make them
contiguous and then select them.

Tell your client that it is poor database design to repeat data from one
column into another or another table (other than the table's Primary Key). A
query should be able to display anything he/she wants to display without
denormalizing and ruining the database.
 
Top