Concatenate

D

David

Hello,
I have a table of 20 columns of text. I would like to
concatenate the values from these 20 columns into
one "sum" column. I had been exporting the file to Excel
and using the Excel "&" function. However the table is now
500k rows and of course that makes exporting to Excel
impractical.

Any suggestions for this non-programmer ?

TIA
 
D

Duane Hookom

Why not create a column in a query like:
BigField:FieldA & FieldB & FieldC & ....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Query to select individual records 4
Multiple IF Statement in Word 5
Excel does not accept text format! 0
Calculate the median value before a specified list 0
dynamic calculated field in query 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Insert Index into a Table 1

Top