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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.