Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

mail mergering access to word document

Discussion in 'Information Technology' started by housing, Jul 28, 2006.

  1. housing

    housing
    Expand Collapse
    Guest

    When trying to mail merge access database to word document, the currency
    field is not displaying the correct dollar amount. If the amount if $495.65
    is is showing this, but if the amount is $400.00. The 400 is showing only
    and not the decimal and the zeroes.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Armed Police Enter Sikh Temple In Birmingham During Protest - Daily Mail Breaking News Sep 12, 2016
    Sikh News Veteran Sikh Soldiers To Inspire Young - Malay Mail Online Breaking News Aug 1, 2016
    Sikh Gmail Calendar Questions and Answers Jul 5, 2016
    UK Daily Mail ISIS entrapment Breaking News Jul 7, 2014
    India India sets up elaborate system to tap phone calls, e-mail Breaking News Jun 20, 2013

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Create a query, and use the Format function on the field (as opposed to
    setting the Format property).

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "housing" <housing@discussions.microsoft.com> wrote in message
    news:638A003C-77E9-4867-843B-07B990B9D02F@microsoft.com...
    > When trying to mail merge access database to word document, the currency
    > field is not displaying the correct dollar amount. If the amount if
    > $495.65
    > is is showing this, but if the amount is $400.00. The 400 is showing only
    > and not the decimal and the zeroes.
     

Share This Page