combine multiple rows into one

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.

All Forums

Other Forums

MS Access

combine multiple rows into one

Author

Topic

mindgasm
Starting Member

2 Posts

Posted - 2008-06-13 : 15:07:23

Hello everybody,

I'm having a dataset of the following form with approx. 35000 records:
Date Object
7/11/2000 08.2
7/11/2000 08.3
7/11/2000 5239.200
4/10/2001 3471.100
20/06/2002 7007
20/06/2002 7007.100
20/06/2002 7007.500
20/06/2002 7007.521
...
...
...

I would like to combine all rows for each date into one row. So for the example-data above this would ideally result in:
7/11/2000 08.2 08.3
4/10/2001 3471.100
20/06/2002 7007 7007.100 7007.500 7007.521
...
...

I work with Access 2007. I know that there are some similar questions on this forum, but they all have PL/SQL solutions.

Any help would be greatly appreciated.

Kind regards,
K

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-13 : 15:10:05

Moving your thread to the Access forum.

I doubt any solutions here are for PL/SQL since that's Oracle and not SQL Server. SQL Server's language is T-SQL.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

mindgasm
Starting Member

2 Posts

Posted - 2008-06-13 : 15:19:19

quote:
Originally posted by tkizer

Moving your thread to the Access forum.

I doubt any solutions here are for PL/SQL since that's Oracle and not SQL Server. SQL Server's language is T-SQL.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Oh yes, you're right. I once heard of procedural languages in SQL, so I thought it was all PL/SQL. My apologies.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources