View Single Post
 
Old April 21st, 2009, 09:29 AM
gbianchi gbianchi is offline
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

Hi Laura...

I know that the SQL you saw looks complex, but that is the correct way to do it.

Since you don't know how much data you have to concat on every record, how do you expect to do it??

Also, are you working with access or sql 2005?? because the solution (in terms on Sql string) could be very different.

Just for information: Query Designer Help
__________________
HTH

Gonzalo


================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the
proof.
================================================== =========

Last edited by gbianchi; April 21st, 2009 at 09:30 AM.. Reason: added pingback from original thread