Concatenating column into 1 field

[flaviooooo]

Hey,

I have the following situation, and have no idea how to solve this:

A table (actually a view, but let's call it table1) contains the following:

Mat Our Material Importdate
1 123 1/10/2007
1 124 1/10/2007
2 321 1/10/2007
3 456 1/10/2007
1 123 2/10/2007
1 124 2/10/2007
2 321 2/10/2007
3 456 2/10/2007

Now I would like to achieve the following, after I filter on the Importdate (via a combobox in my program, I select 1/10/2007)

1 123/124
2 321
3 456

As you see, the values linked to mat 1 are 'concatenated'

I can't find a way to do this in SQL and do it now in my MS Access frontend (with a loop that runs awfully long...)

Any help would be appreciated

Grtz
Fabian

 

[bborissov]

You could search here in FAQ for concatenation functions. But I have one question: What will happen if you have 732 records for ONE Mat in the same DATE?
Your record will look like this:

1 123/124/125/125/126/127...............
  ......................................
  ................................../732

And don't tell me that would never happens

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[flaviooooo]

That never happens

It's about 3 or 4 records for 1 mat maximum

I'll check the FAQ for answers...

 

[AlexCuse]

take a look at this thread:

thread183-1159740

Hope it helps,

Alex

[small]----signature below----[/small]
According to recent reports, the US Missile Defense System is actually just Cole Hamels on Speed Dial.

Ignorance of certain subjects is a great part of wisdom