Link to home
Start Free TrialLog in
Avatar of cnv1
cnv1

asked on

Merging and Access Query

I have an Access Query that will be used to generate a letter to each supplier to notify them of the estimated purchases for the month by location.  There are mulitple locations per supplier.  I need to know how to make word group the locations for each supplier on one page.

I need it to look like  this:

Supplier A

Location A     Amt
Location B     Amt

Supplier B    

Location C     Amt
Location D     Amt
Location E     Amt

etc..

I can mail merge but it is putting one location per page and that is not what I want.  Once I figure out how to group the locations by supplier, I will also need to set up a routine that takes each supplier and creates a separate word file for distribution.

Thanks

ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cnv1
cnv1

ASKER

Hi-

Sorry for the delay,  I ended up doing this a different way in the interest of  but I'm filing this suggestion away for future use as I am going to revisit the process.

Thanks and again I apologize for the delay.