If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
move data in a column from selected rows into a new column
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. |
#2
|
|||
|
|||
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? -- Good luck Jeff Boyce Access MVP "susanne in new jersey" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
Inserting multiple rows into a table while maintaining data? | JAnderson | General Discussion | 2 | July 8th, 2004 05:45 PM |
How do I match one column of data to another when they have a different number of rows? | Frank Kabel | Worksheet Functions | 5 | March 23rd, 2004 02:14 PM |