C_sharp_beaver
asked on
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)
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Yes I know you can do it in other DBMSs but you can't do it in Access without using a VBA function.
ASKER
Unfortunatelly it's "no win" situation but it was important expert opinion to backup my personal position in this request
If you google for
Access concatenate records
you will find enough sample functions to convince anyone that you can't do it without one.
Access concatenate records
you will find enough sample functions to convince anyone that you can't do it without one.
ASKER
My boss asking about single SELECT query