Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
geossl
Yak Posting Veteran
85 Posts |
 Posted - 2004-01-08 : 20:54:53
|
| Dear All,There is a tableID Name-- -----1 Peter2 Mary3 PauLI would like to get all these three records and return in a single field, that is, PeterMaryPaulIs it possible to do with SQL in Access?Thanks. |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2004-01-09 : 01:32:04
|
| Why do it in SQL? This is an iterative process, so you may as well do it in VBA. You can do this in T-SQL (SQL Server), and there are many such solutions on this site, but in Access I'm pretty sure it can't be done, at least, not without reverting to VBA somewhere along the line...Is there some reason you can't use VBA?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Concat different rows to single row single field