<div>
are you querying Access DB or are you using only Access interface to query a MS SQL database? 
</div>


are you querying Access DB or are you using only Access interface to query a MS SQL database?

<div>
This is good. &nbsp;I think I can make this work. &nbsp;Thanks!
</div>


This is good.  I think I can make this work.  Thanks!

<div>
<div class="content wysiwyg-content">
I would like a function that I can use in a Totals/Group By query in Access where this:<br />
<br />
Truck &nbsp; SONum<br />
WC &nbsp; &nbsp; 234567<br />
WC &nbsp; &nbsp; 233555<br />
EC &nbsp; &nbsp; &nbsp;236666<br />
EC &nbsp; &nbsp; &nbsp;235777<br />
<br />
<br />
becomes this when grouping by Truck:<br />
Truck &nbsp; &nbsp; &nbsp;SONumCSV<br />
WC &nbsp; &nbsp; &nbsp; &nbsp; 234567, 233555<br />
EC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;236666, 235777<br />
<br />
<br />
I found this, but I'd rather have a function that I can just use in the aggregate within a Totals/Group By query.<br />
<a href="https://www.experts-exchange.com/questions/23534323/Getting-data-from-an-Access-table-to-appear-as-a-comma-seperated-list.html" rel="ugc">https://www.experts-exchange.com/questions/23534323/Getting-data-from-an-Access-table-to-appear-as-a-comma-seperated-list.html</a><br />
<br />
Can someone help?<br />
<br />
BTW, Happy New Year!<br />
<br />

</div>
</div>


I would like a function that I can use in a Totals/Group By query in Access where this:

Truck   SONum
WC     234567
WC     233555
EC      236666
EC      235777


becomes this when grouping by Truck:
Truck      SONumCSV
WC         234567, 233555
EC          236666, 235777


I found this, but I'd rather have a function that I can just use in the aggregate within a Totals/Group By query.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23534323.html

Can someone help?

BTW, Happy New Year!



Creating a comma separated list as a Function to be used in a Totals/Group By query

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.