Concatenate from multiple rows

[ciarra41]

Hello;
I have a table like this

Field1, Field2
Bar slice
Bar candy
Bar milk
Tom blue
Tom candy
Tom slice
I’m trying to concatenate them into one filed1 separate by commas for Field2

Filed1, Filed2
Bar slice, candy, mild
Tom blue, candy, slice

 

[straybullet]

Check out this FAQ

Let them hate - so long as they fear... Lucius Accius

 

[ciarra41]

I keep getting "user-define type not defied" error. What are your suggestions?

 

[dhookom]

What did you try? Did you copy or import the module into your MDB? Does your code compile?

What is the expression you used in your query? What are the data types of the "join" field?

Duane MS Access MVP