General discussion

  • Creator
    Topic
  • #2189299

    currency conversion in Access

    Locked

    by john.a.wills ·

    I have a table with a currency field. I want to convert the currency field to a number with two decimal places for export. I insert into a long integer field in a second table, and the cents and the decimal point get lost. When I export I get the numbers left justified. What type specifications should I be using in my second table?

All Comments

  • Author
    Replies
    • #3069539

      Reply To: currency conversion in Access

      by john.a.wills ·

      In reply to currency conversion in Access

      When I make the field in the second table fixed I get suitable-looking numbers. But I still get left justification at export.

    • #3069180

      Reply To: currency conversion in Access

      by calson ·

      In reply to currency conversion in Access

      You need to insert it into a double field with decimal places set to two.

      • #3069117

        Reply To: currency conversion in Access

        by john.a.wills ·

        In reply to Reply To: currency conversion in Access

        No, the numbers still came out left-justified at export, with no decimal points and with the (all zero this time) cents missing.

        • #2819654

          Similiar Problem

          by wyscavern ·

          In reply to Reply To: currency conversion in Access

          I have a similiar problem. Although I got all the numbers to come through including the cents, it keeps rounding up to the nearest dollar and I need exact amounts. Here is my code for formatting. I need extra zero’s in front of the actual amount so I can download into another database.
          Right((String(12,”0″)+Replace(Replace(FormatNumber([Cash Receipt Total],0),”.”,””),”,”,””)),10)+’00’.
          The formatting works perfect for me, but when I have 22.50 it comes out to be 2300, which will not work. I cannot figure out why it is rounding or where in my formula I tell it to round???

Viewing 1 reply thread