Grouping records

[Robster]

got the concat working.
the actual table has 24516 records so when i run the query it comes up with not responding.

 

[jdraw]

?? it' a query. Does it run for 10 records? How did you test it?
Do you have some records with null/empty string or missing data?

Can you post a copy of the database (zip format)? We don't need the full database necessarily--100-200 records should be sufficient.

You might want to check your records for missing values.