<div>
see <a href="http://stackoverflow.com/questions/970481/concat-all-column-values-in-sql" rel="ugc">http://stackoverflow.com/questions/970481/concat-all-column-values-in-sql</a>
</div>


see http://stackoverflow.com/questions/970481/concat-all-column-values-in-sql [http://stackoverflow.com/questions/970481/concat-all-column-values-in-sql]

<div>
coachman99, no thanks, but using methods not in vba
</div>


coachman99, no thanks, but using methods not in vba

<div>
<div class="content wysiwyg-content">
access 2010<br />
<br />
What I have :<br />
1 table &nbsp;=MyTable<br />
2 fields<br />
MySku-text-dups<br />
MyDesc-text-dups<br />
<br />
<br />
I have data in the table like this<br />
<br />
MySku &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MyDesc<br />
1234A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Apples<br />
3EER4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Oranges<br />
1234A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Peaches<br />
232AW &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PIE<br />
3EER4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PINEAPPLE<br />
<br />
<br />
What I need:<br />
<br />
I need to create a new query like this:<br />
Concatenate the MyDesc into one line<br />
1234A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;APPLES:PEACHES<br />
3EER4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ORANGES:PINEAPPPLE<br />
232AW &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PIE<br />
<br />
<br />
etc....<br />
<br />
<br />
<br />
Thanks<br />
fordraiders
</div>
</div>


access 2010

What I have :
1 table  =MyTable
2 fields
MySku-text-dups
MyDesc-text-dups


I have data in the table like this

MySku            MyDesc
1234A            Apples
3EER4             Oranges
1234A            Peaches
232AW           PIE
3EER4             PINEAPPLE


What I need:

I need to create a new query like this:
Concatenate the MyDesc into one line
1234A              APPLES:PEACHES
3EER4               ORANGES:PINEAPPPLE
232AW             PIE


etc....



Thanks
fordraiders

Crete unique table with concatenation of second field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.