Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Question Unanswered: How to calculate a margin

    Hopefully a no brainer but as ever I struggle with the techie terms and can't lookup help!!!

    In layman terms...

    I have a table with two fields..

    1) Cost (cost of purchase) = $12
    2) Price (price sold) = $23

    I want to calculate the margin at which it is sold e.g. price - cost x 100 = %age margin

    How the **** do I get this to work, sounds easy to do as it is nothing like rocket science but asa ever it evades me! If you can point me in the right direction with some instructions or with the right term to dig around the 'net for help I'd be very grateful.

    Fortune Global 500 Databank

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    How are your tables set up? You can write formulas in queries similar to using a spreadsheet, but where the data comes from is going to depend on how you setup your tables.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2003
    The only way that I've ever done margins is by taking the cost and multiplying by the margin Ex:

    Cost X * 1.085 = Price [8.5% markup]

    So: Do the math ... Margin = Price / (Cost * 100)
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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