Sub Table Question

[Jeff]

Greetings, Kinda a noob question I think. I have a table witn customer Info.
I would like to "Group" Customers by customer number. i.e. John doe has had 5
orders in the past and I would like to mail him a letter listing all 5
orders. the trouble is i am unsure how to "group" all the customers by their
numbers. so i dont send john doe 5 letters make sense? Any Help would be
great.

 

[Allen Browne]

Use a report to create these letters.

1. Create a query that contains the information from the customer table as
well as the order table.

2. Create a report based on this query, with a Report Header and a Report
Footer based on the customer number.

3. In the CustomerID Report Header, put the address panel in the right place
to fit a window-faced envelope.

4. In the Detail section, but the fields for the order.

5. In the CustomerID Report Footer, put the signature for your letter. Set
the Force New Page property of this section to After Section, so each new
letter starts on a different page.

 

[Jeff Boyce]

Jeff

If you have a customer table, do you uniquely identify each customer? Or is
your customer info table more like a spreadsheet, with one row for each
customer-order?

Regards

Jeff Boyce
Microsoft Office/Access MVP