Feb 20, 2008 #1 ciarra41 Technical User Joined Sep 11, 2006 Messages 116 Location US 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
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
Feb 20, 2008 #2 straybullet IS-IT--Management Joined Jun 5, 2003 Messages 593 Location US Check out this FAQ Let them hate - so long as they fear... Lucius Accius Upvote 0 Downvote
Feb 20, 2008 Thread starter #3 ciarra41 Technical User Joined Sep 11, 2006 Messages 116 Location US I keep getting "user-define type not defied" error. What are your suggestions? Upvote 0 Downvote
Feb 20, 2008 #4 dhookom Programmer Joined Jun 24, 2003 Messages 22,560 Location US 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 Upvote 0 Downvote
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