How to select values in a column n put it in new column

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

Can someone tell me how I can select all the values (e.g 4
rows) in a column and put it in a new column)
 
Cindy

Why? As in "why do you need to copy data from one column to another?"
Redundant data carries with it a host of problems, starting with having to
keep both sets of data synchronized. So again, why do you think you need to
do this?
 
Ok, let me explain in more details.

I have two columns:

Col1 Col2
---- ----
a abcde
b
c
d


Now, I would like to have col2 = abcd for everyrow... like
in excel, we have the function concatenate .. but in
access, we dont and I dont know how to add up the rows in
col1 to become col2

Col1 is only part of the data I get from a formula, the
actual value I need must make up by adding the four rows
in col1.
 
I'll ask again. Why, if you have the information already stored, do you
need to store the same information again? And if your example is accurate,
why do you need to store the same value for each row (into Col2)? A query
can be used to create, on the fly, the concatenated values.

There was a recent post to the queries 'group asking about concatenating
values from multiple rows -- I believe the responder sent the poster to the
mvps.org website.
 
Back
Top