reorganizing data

R

Russ

I have a table that is set up for customer purchases. It has 3 columns,
customer name, company, and the item they purchased. If the company
purchased more than 1 item they are given more than one record. Most
companies have several records. I need it set up this way becasue it is used
in a subform in my database.

My problem is I need to mailmerge these items with word but I want all of
the items purchased by one company to appear in one record. Right now I can
several different word documents becasue each company has more than one
record. how do i get all of the item each company purchased into one record?

thank you for your help
 
J

James Hahn

Instead of mailmerging the ACCESS data with WORD, why not use an ACCESS
report to produce the documents? An ACCESS Report can easily handle the
problem of some companies having a few purchases and some companies having
many purchases, and still get all the purchase data onto one report (that's
why your database is organised like this). Organizing a WORD mailmerge to
do this would be difficult, because it is designed to produce one document
per record (as you have discovered).
 
R

Russ

I have tried to write my report in access but it ends up lookinglike a data
sheet as opposed to the word document that I need. it really needs to be in
teh form of a letter. I am not sure if this is possible with access? any
suggestions either way?
russ
 
Top