Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Maine, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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.

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    Maine, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •