Access Calculations

Results 1 to 2 of 2

Thread: Access Calculations

  1. #1
    Join Date
    Dec 1969

    Default Access Calculations

    Hey,<BR>In Access:<BR>How can i convert currency to a 2 decimal number, do some caluculations, then convert the result to currency format again. <BR><BR>Thanks all!<BR>Kyle<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Access Calculations

    You mean something like this:<BR><BR>UPDATE table <BR>SET currencyFld = CCur( 1.3 * CDbl( currencyFld ) )<BR>WHERE somecondition<BR><BR>???<BR><BR>That doesn&#039t convert it to a decimal converts it to a real number...but that is more than likely the right thing to do, as the currency will presumably already be 2 digits to the right of the DP. That is *UNTESTED* but I think it will work. Let me know!<BR><BR>

Posting Permissions

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