PhxDB
asked on
Combining Text Fields in Access
Hello - Recently asked the following question for Excel (https://www.experts-exchange.com/questions/28370854/Excel-Combining-Text.html). The Excel solution was to use Index and Match to create the additional columns ... which worked ... but thought it would probably be much easier to do in Access.
Basically have a Table with two fields (i.e. ABC and Remarks) and want a query to put all the A remarks together on one line, same with the B's and C's something like below.
Col1 Col2
A Remark1
A Remark2 A Remark1 Remark2 Remark3
A Remark3 to B Remark4 Remark5
B Remark4 C Remark6 Remark7 Remark8 Remark9
B Remark5
C Remark6
C Remark7
C Remark8
C Remark9
Would appreciate some assistance on what would be the best way to go? Thanks.
Basically have a Table with two fields (i.e. ABC and Remarks) and want a query to put all the A remarks together on one line, same with the B's and C's something like below.
Col1 Col2
A Remark1
A Remark2 A Remark1 Remark2 Remark3
A Remark3 to B Remark4 Remark5
B Remark4 C Remark6 Remark7 Remark8 Remark9
B Remark5
C Remark6
C Remark7
C Remark8
C Remark9
Would appreciate some assistance on what would be the best way to go? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER