I have data that looks like this: ID Value 1 Descr1 1 Descr2 1 Descr3 where Descr could range from 1 to 100 for each ID The result set I need is: Greetings, Would it be possible to construct SQL to concatenate column values from multiple rows? SELECT FROM T1, T2 WHERE T1.key=T2.fkey (group by key?); Possible Duplicate: Ms Access Query: Concatenating Rows through a query. I have a table that has many columns, but two of interest: Order Number and Product Type.
sql - Access Concatenate rows into single. Microsoft Access Discussion > Queries Hi to everybody, I need another help, I created a query with several field, when the To concatenate the fields, you will
Concatenate Rows into Columns - Microsoft.
Hi , I have a table with one column Output .it has values as below.But i need them in one row.How to write a query for this. Output 'testing the scenario.exe' is not
access concatenate rows
Concatenate column values from multiple. I have a table 2 columns (Object and Weight) with data like below: Object Weight(lb) table 5 Chair 6 Computer 3 Computer 5 TV 20 TV 15 Radio 10 Computer 10 Question
sql - Concatenate multiple rows in one. I'm working with an Access database and I need to concatenate different related rows into 1 row. I found a solution here and used it with great success.
Concatenate Column Values from Multiple.
I have data that looks like this: ID Value 1 Descr1 1 Descr2 1 Descr3 where Descr could range from 1 to 100 for each ID The result set I need is:
Greetings, Would it be possible to construct SQL to concatenate column values from multiple rows? SELECT FROM T1, T2 WHERE T1.key=T2.fkey (group by key?);
Possible Duplicate: Ms Access Query: Concatenating Rows through a query. I have a table that has many columns, but two of interest: Order Number and Product Type.
sql - Access Concatenate rows into single.
Microsoft Access Discussion > Queries Hi to everybody, I need another help, I created a query with several field, when the To concatenate the fields, you will
Hi , I have a table with one column Output .it has values as below.But i need them in one row.How to write a query for this. Output 'testing the scenario.exe' is not
access concatenate rows
Concatenate column values from multiple.
I have a table 2 columns (Object and Weight) with data like below: Object Weight(lb) table 5 Chair 6 Computer 3 Computer 5 TV 20 TV 15 Radio 10 Computer 10 Question
sql - Concatenate multiple rows in one.
I'm working with an Access database and I need to concatenate different related rows into 1 row. I found a solution here and used it with great success.
Access Concatenate Expression
sql - Concatenate multiple rows in one.
access concatenate rows
concatenate multiple rows into a single.
Concatenate in Access Table