<div>
Can you please concentrate deeper in your mind ? &nbsp;:o)<br />
My boss asking about single SELECT query<br />

</div>


Can you please concentrate deeper in your mind ?  :o)
My boss asking about single SELECT query


<div>
Still the same answer. &nbsp;There is no feature in Access/JET SQl which will create a single field from multiple records.<br />
Yes I know you can do it in other DBMSs but you can't do it in Access without using a VBA function.
</div>


Still the same answer.  There is no feature in Access/JET SQl which will create a single field from multiple records.
Yes I know you can do it in other DBMSs but you can't do it in Access without using a VBA function.

<div>
Unfortunatelly it's &quot;no win&quot; situation but it was important expert opinion to backup my personal position in this request
</div>


Unfortunatelly it's "no win" situation but it was important expert opinion to backup my personal position in this request

<div>
If you google for <br />
Access concatenate records <br />
you will find enough sample functions to convince anyone that you can't do it without one.
</div>


If you google for
Access concatenate records
you will find enough sample functions to convince anyone that you can't do it without one.

<div>
<div class="content wysiwyg-content">
Non-standards question :o)<br />
<br />
I have data approx of this structure<br />
<br />
record_id &nbsp; &nbsp; &nbsp; &nbsp; var_01<br />
==================<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Andy<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Alex<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Anny<br />
.....<br />
<br />
My task to select specific records and return Var_01<br />
I need to return them as ONE record separated by &quot;;&quot; - something like<br />
<br />
Andy;Alex;Anny;<br />
<br />
Currently I use loop to get them separately and combine them on &quot;client&quot; side<br />
<br />
The question - can I create query to return them in one record?<br />
I cannot use stored procedures or functions (Access DB)
</div>
</div>


Non-standards question :o)

I have data approx of this structure

record_id         var_01
==================
1                       Andy
2                       Alex
3                       Anny
.....

My task to select specific records and return Var_01
I need to return them as ONE record separated by ";" - something like

Andy;Alex;Anny;

Currently I use loop to get them separately and combine them on "client" side

The question - can I create query to return them in one record?
I cannot use stored procedures or functions (Access DB)

SELECT and MULTYRECORD result

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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.