MS Word Mail Merge Problem
Posted on 2004-04-17
I'm having trouble with mergefields in Word. I cannot get the 'Next' or 'Nextif' fields to work! Background:
I have a a simple library database in Access 2K. I also working with MS Word 2K. The database has three tables: Members, Books, and Loans. the relationships are:
One - 2 - many
Member - 2 - Loans
Loan - 2 - Books
Now, I created a Query that gets all the data from all the tables where the DateDue<Today's Date.
then I created a mail merged Word document. I want to print the Word document so that it displays all overdue books and their details for each Member who has overdue books.
The crux of the problem is that I don't know how to display ALL the overdue books in each letter where each letter is to individual Members.