Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem Transferring Query to Word Merge (2000)

    I have a query that has a field that calculates the Total Due. I have formatted it to be Standard, with 2 Decimal Places. But when I merge the document into Word, it is with no decimal places. (e.g. 18.40 merged is 18.4, or 40.00 merged is 40). Is there any way to have it keep the format when I merge it?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem Transferring Query to Word Merge (2000)

    You should format the merged field in the word document.
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem Transferring Query to Word Merge (2000)

    For some reason I'm having a complete brain blockage! How do I format the number in Word? I can't seem to find anywhere where it formats numbers.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem Transferring Query to Word Merge (2000)

    Use something like :
    { MERGEFIELD YourField # #,##0.00 }
    In the index of the help in word type : Field
    Scroll down to Field codes: MergeField field
    You can click on the little arrow after For more information to go to General Switches
    There you can choose between the different type of fields.
    Francois

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem Transferring Query to Word Merge (2000)

    Wow, I learn something new every day! Thanks, Francois.

Posting Permissions

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