View Single Post
  #1   Report Post  
Frank Spade
 
Posts: n/a
Default 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.