move data in a column from selected rows into a new column

[susanne in new jersey]

I have rows of bills. I've found the bills that I want to separate. I want to
copy the dates of these bills only into a new column. Can't figure out how to
do this.

 

[Jeff Boyce]

It's kinda hard to visualize what you're talking about. Are you asking for
ideas about tables in MS Access (this newsgroup focuses on table design)?

If your table already has "the dates", why do you need "to copy [them] ...
into a new column"? Having the same values stored redundantly in a table
shouldn't be necessary in a well-normalized design.

Have you looked into using an update query?