SELECT and MULTYRECORD result

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)
C_sharp_beaverAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
"The question - can I create query to return them in one record?
I cannot use stored procedures or functions (Access DB) "

NO. Can't be done without a function.
0
 
C_sharp_beaverAuthor Commented:
Can you please concentrate deeper in your mind ?  :o)
My boss asking about single SELECT query
0
 
peter57rCommented:
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.
0
 
C_sharp_beaverAuthor Commented:
Unfortunatelly it's "no win" situation but it was important expert opinion to backup my personal position in this request
0
 
peter57rCommented:
If you google for
Access concatenate records
you will find enough sample functions to convince anyone that you can't do it without one.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.