I’m updating an old Word file that gets merged with an old Access database. Both were originally created seven years ago, using Word 97 and Access 97, although I’m now using Word 2007 and Access 2007.
For the most part, the merge works perfectly, but there are two sets of fields (four fields total) in which the data gets reversed during the merge. I’ve tried everything I can think of, including deleting the mergefields from the Word file and re-inserting them, to no avail.
Here’s what’s in the Word file:
New procedures distributed by: «New_SOPs_distributed_by» Date: «New_SOPs_distributed_date»
Notification of implementation date by: «Notification_of_imp_date_by» Date: «Notification_of_imp_date_date»
Here’s what the merged file should display:
New procedures distributed by: My Name Date: 1/1/09
Notification of implementation date by: My Boss’s Name Date: 2/2/09
But here’s what displays after the merge:
New procedures distributed by: My Boss’s Name Date: 2/2/09
Notification of implementation date by: My Name Date: 1/1/09
Does anyone have any idea what could make this happen? Or better yet, what I can do to fix it?
Thanks!