Help on how to concatenate row values using a query

[halohappy]

Hi, I have a table „Pmt“ in Ms Access with following information:

Table “Pmt”
Cust no Inv no T no Date Amt
123 ABC T1 20110131 1000
123 ABC T2 20130228 1000
123 ABC T3 20130331 1000
789 XYZ A1 20130131 2000
789 XYZ A2 20130228 2000

Fields "Cust no", "Inv no" and "T no" are in Text format, whereas "Date" and "Amt" are in Number.

My question: how can I concatenate row values using a query. The query results that I wanted are as follows:

Cust no Inv no T no Date Amt
123 ABC T1, T2, T3 20130131, 20130228, 20130331 3000
789 XYZ A1, A2 20130131, 20130228 4000

Thanks in advance.

 

[rzw0wr]

[cust no] & [Inv no] & [T No] & [Date] & [amount]

Note: Remove ALL spaces from your field names.
Make Date a date type IF it is a date.
Dale

 

[Galaxiom]

I think you need something like this solution.
http://www.access-programmers.co.uk/forums/showthread.php?t=221397

It will add as many fields as required to list all invoices for each customer in one row.

Once you get that you can concatenate the fields as required.