Merging data from two consecutive access records in Word 2002
I have an access table with records of members and their partners. They are
next to each other in the table.
I want to print one address lable for each pair (to save postage) in the
form
firstname & fristname+1 lastname
address
city, state zip
skip 1 record
where firstname+1 is the supposed to be the reference to the firstname
field of the next record and skip 1 record indicates that one record is
to be skipped to point to the next pair once one label is printed.
Does Word have a syntax that allows to do this oder is there another way to
do it?
Thank you for any helpful advice.
|