Results 1 to 3 of 3
  1. #1
    BEI77 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2014
    Location
    KY
    Posts
    24

    Need help with a calculation

    I HAVE A FIELD THAT I NEED TO CALCULATE USING THIS FORMULA Round([D17]*[C59]/[D9],2)



    I NEED [D9] TO BE TO THE 2ND POWER. IS THIS THE RIGHT WAY TO WRITE IT?

    THANKS.

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    I believe to the Power of is ^. so 3 to the power of 2 would be written as 3^2

  3. #3
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Try:
    Code:
    Round(([D17]*[C59])/([D9]^2),2)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Calculation Field in table vs Query calculation
    By Leonidsg in forum Database Design
    Replies: 18
    Last Post: 02-28-2013, 09:38 PM
  2. Calculation
    By magootrp4 in forum Programming
    Replies: 1
    Last Post: 03-12-2012, 12:38 PM
  3. Calculation
    By sabrish72 in forum Reports
    Replies: 3
    Last Post: 06-06-2011, 12:41 AM
  4. How to do calculation???
    By latestgood in forum Forms
    Replies: 0
    Last Post: 05-18-2011, 11:11 AM
  5. value calculation
    By kyle in forum Access
    Replies: 3
    Last Post: 03-06-2011, 12:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums