Need help ASAP.
I have a table with a description field and three columns next to it, one for each corresponding code. I need to merge the three columns into one.
ex.
description C1 C2 C3

outcome:
description C1
                C2
                C3
Anyone?
Thanks a lot!
Cynthia

Just to clarify, do you want each moved into the same record in the same column or each into the same column but a different record?

Mike

Mike
EchoVue.com

Each description might have up to three codes. And I need to show the description on one row,then on the next column the first code, under the same row. For the second code (still for the same description) it will be on the next row but on the code column.

Hope this clarifies my question.

Thanks!
Cynthia

Personally, I would create a new table with 2 columns - Description and Code.

Next I would set up 3 append queries to append to that table.

The first would be Description & C1 where C1 <> ""
The second would be Description & C2 where C2 <> ""
The last would be Description & C3 where C3 <> ""

Finally, just sort by description to get them in order

HTH - Yell if you have any questions.

Mike

Mike
EchoVue.com