Custom Letters with Grouped Information

[coolxten]

Hi, I'm having trouble finding an answer because I don't really know how to search for an answer to my problem.....Here it goes....

I have a list of data that looks like this in excel....

Customer ID | Product | Price | Date
001|TV|$100|12/10
001|VCR| $50|09/10
002|TV| $100|09/10
003|Audio|$25|3/10
003|Cables|$10|5/10
003|TV|$100|9/10
... |...|...| ...

I need to create a letter that summarizes each customer's purchase history....Letter would look like this example below;

Dear Customer,

Thank you for shopping with us, in 2010 you purchased;

Customer ID | Product | Price | Date
003|Audio|$25|3/10
003|Cables|$10|5/10
003|TV|$100|9/10

Please let us know if the above list is incorrect.

Thank you

I need to produce a similar letter for 250 unique customers. Normally I would arrange in excel, and copy and paste the data in to a letter template in word, and print each time. There's gotta be some way to do this in access. Does anyone know where I can find a step by step tutorial to do this in access?

Thanks in advance!

[coolxten]

Can any one help?

[Access_Blaster]

Try this:

Create a new select query using Customer ID | Product | Price | Date
Then create a new report using the wizard based on your new query.
As you go through the steps it will ask you what you would like to group on. Try Customer ID first. Experiment with different fields to group on. Do you have a customer field?

Richard