Re: Report help

James wrote:
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/Otherdownload.asp?SampleName='Generic%20Function%20To%20Concatenate%20Child%20Records'

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.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: stuff-uk.net - - Horrible service, AVOID THEM!!
    ... >Bubsio AKA James Taylor ... >discuss the problem with the manufacturer. ... respect - the contract is between retailer and customer, ...
    (uk.comp.vendors)
  • Re: How do I get a list of available tables?
    ... USE Northwind ... --This will list all the Tables which have term 'Customer' in the name ... Rohtash Kapoor ... "James C" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Nearly identical records in a table.
    ... Each record for a customer is nearly identical except for some dollar ... amounts and a creation date field. ... James O ...
    (microsoft.public.access.queries)
  • Kyocera 9100 API driver
    ... I need to program the stapler in Kyocera 9100 from my application. ... problem is that customer wants some reports to be stapled. ...
    (comp.periphs.printers)