Copy data from one column to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mlthomas007 - 12 May 2008 16:15 GMT

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.

Reply to this Message

Arvin Meyer [MVP] - 12 May 2008 17:55 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks.

Reply to this Message

Rate this thread: