Merge Access Query w/many-to-one relationship

[jdgretz]

Here's the problem:
A client needs to send out letters to clients showing open invoices from
their organizations. A Access Report built from a Query does this just fine,
but it's not a Mail-Merged letter.

Master Company Record
Division name
Division invoice
Division invoice
Division invoice
:
Division 2 name
Division 2 invoice
:
Division 2 invoice

Works fine as an Access Report - also the report exports correctly to a
grouped Excel spreadsheet, but with each invoice on a separate line
mail-merge only picks up the first invoice instance. Using the Access query,
I get a separate letter for each invoice - not what the client wants. Client
wants a single letter to each Corporation or master company showing all the
invoices for that master record.

Ideas??

John

 

[Graham Mayor]

See How to use mail merge to create a list sorted by category -
http://support.microsoft.com/?kbid=294686

Fellow MVP 'macropod' has posted a tutorial on this, with working field
codes and a sample Excel data source, at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>