Report help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
James said:
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
Click to expand...


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.
 
Back
Top