Query concatenation help

[Guest]

Hi,

I have a table with customers and orders. It looks something like:

Date / Customer / Order
1/07 / James / Stapler
2/07 / James / Paperclips
3/07 / James / Post-Its

Is there a way to create a query so that it out puts all the orders for one
customer into one summary field like so?

Customer / Order
James / Stapler, Paperclips, Post-Its

Thanks!

 

[Guest]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.