Link to home
Start Free TrialLog in
Avatar of PhxDB
PhxDBFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PhxDB

ASKER

Awesome - Thanks!