• Merging with Word; fields reverse (2007)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Merging with Word; fields reverse (2007)

    Author
    Topic
    #458042

    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!

    Viewing 0 reply threads
    Author
    Replies
    • #1150354

      Without seeing the document and data source I can only suggest that you check and double check that the data haven’t become messed up in the data source.

      • #1150379

        Thanks for the suggestion, Hans.

        I did look at the data, but not at closely as I probably should have before I posted my question here. Let’s hope the solution is that simple! (Not that bad data is a good thing, but in this case I wouldn’t mind–it’s my boss’s database so I wouldn’t have to feel guilty.)

    Viewing 0 reply threads
    Reply To: Merging with Word; fields reverse (2007)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: