Report 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 report 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!

 

[Marshall Barton]

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 report so that it out puts all the orders for one
customer into one summary field like so?

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

You need to create a function to do that. There's a good
one at:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

Strip the report's record source query down to just
SELECT DISTINCT Customer FROM Orders

Then use the function in your orders text box's control
source expression.

 

[Guest]

Thanks so much! This is exactly what I was looking for!