Combine record entries

[cactuspete13]

Not sure if this is possible but I thought I'd ask. Is it possible to group multiple items grouped by a like id. For example, a table (worktbl), has the following columns: ID (auto number), CustomerName (text), PurchaseDate (Date/Time). In the table are three entries for John Smith, ID is 1, and the following dates: 1 Feb 14, 1 Mar 14, and 1 Apr 14. What I am trying to do is get a query to return one entry with the three dates listed in one block separated by commas: John Smith; 1 Feb 14, 1 Mar 14, 1 Apr 14

[lfpm062010]

I have done that in VBA and create the resualt in a table.
I have also try that in query but not as clean as it would have in VBA.

[ranman256]

That sounds like you want a 'crosstab' query. Try it with the query wizard.