combining rows

[Guest]

I am accessing a SQL server database that stores a description specific to an
account in a separate row for descriptions. I want them all to be in one row
with my account, i.e. Account, desc1, desc2

What I'm getting now is: Account, desc1
Account, desc2

In my mind I want to say if the account number on the next line is the same
move desc2 to prior line, but have no idea if that's even possible.

 

[Douglas J. Steele]

What you're thinking of isn't really possible.

In Access, you can simulate it through the use of a function such as what's
shown at http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web".

While you could use the same approach in your case, I think you'll find
it'll be faster to have a stored procedure in SQL Server that does that for
you.