By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,790 Members | 1,426 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,790 IT Pros & Developers. It's quick & easy.

Double Merge in a Access Report Possible??

P: n/a
Have two tables in a database.

Addr: Name, Address, City, State Zip

Class: Class Name, Start Date End Date

What I would like to do is print one letter for each record in the
Addr table and in the body of the letter would print a line for each
record in the class table

ie Sort of like this
Memorandum To: Name
Address
City, State, Zip

Here are a list of available classes

class name start date end date
class name start date end date
...
...
class name start date end date

Is this possible just using Access or can is be done using Access &
Word. Can't seem to figure out the logic on either.

Any suggestions, directions would be very much appreciated
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Create a Report with the information you want on the lines in the body of
the Report, with a RecordSource of the Class Table or a Query on that Table.
Create a Report with the information about the person as the form letter,
then add a Subreport Control, into which you embed the Form with the Class
information.

Larry Linson
Microsoft Access MVP

"Jeffro" <je**********@dhs.gov> wrote in message
news:c3*************************@posting.google.co m...
Have two tables in a database.

Addr: Name, Address, City, State Zip

Class: Class Name, Start Date End Date

What I would like to do is print one letter for each record in the
Addr table and in the body of the letter would print a line for each
record in the class table

ie Sort of like this
Memorandum To: Name
Address
City, State, Zip

Here are a list of available classes

class name start date end date
class name start date end date
...
...
class name start date end date

Is this possible just using Access or can is be done using Access &
Word. Can't seem to figure out the logic on either.

Any suggestions, directions would be very much appreciated

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.