Results 1 to 5 of 5
  1. #1
    KarlT is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Posts
    2

    Microsoft Access - Stamp Duty Calculation

    Hi there,


    I am new to access and I am trying to build a calculator for when I am buying a buy to let property. I am trying to find the query for second property Stamp duty and failing miserably at every turn.
    I have found one for excel but it make no sense to me at all and do no have a clue on how to translate it into access even if it is possible.

    this is what it looks like in excel:
    =SUMPRODUCT(--(B4>{125000;250000;925000;1500000}), (B4-{125000;250000;925000;1500000}), {0.02;0.03;0.05;0.02})+(B4*IF(B4>39999,0.03,0))

    If you are good enough to answer or help please be gentle as I really do not have a clue and I am in at the deep end with little knowledge and understanding of terminology. Thank you in advance

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In Access you build a table of rates.
    or a custom Function or both.

    what is the calculation you want to do? (Not in excel terms, in English)

  3. #3
    KarlT is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Posts
    2
    In English...... that helps me too. thank for the reply by the way.
    If I purchase a second property I need to calculate the stamp duty.
    £0-£39999 is 0% of purchase price in Stamp duty
    £40000 - £124999 is 3% of purchase price in Stamp duty
    £125000-249999 is 5% of purchase price in Stamp duty
    £250000-924999 is 8% of purchase price in Stamp duty
    £925000-£1499999 is 13% of purchase price in Stamp duty
    £1.5 over is 15% or Purchase price in stamp duty

    so if I am to purchase a property at say £150000 the calculation is 125000 * 3% (3500) + 25000 @ 5% (1250) so the total stamp duty to be paid is £5000

    I hope this makes sense? thank you again

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Then you want a Rate table.
    The table:
    StartRng, EndRng, Rate

    then the query pulls the rate given the Value to search in the range.
    pretty much everything is done in tables.

  5. #5
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    cross posted here with answers

    https://www.access-programmers.co.uk...27#post1586827

    @Karl -= please read this thread about the dangers of cross posting http://www.excelguru.ca/content.php?184

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

Similar Threads

  1. Replies: 2
    Last Post: 01-15-2018, 07:46 PM
  2. Replies: 3
    Last Post: 02-23-2016, 12:16 PM
  3. Importing Information From Microsoft Word to Microsoft Access
    By Runlynch in forum Import/Export Data
    Replies: 9
    Last Post: 01-17-2016, 06:21 PM
  4. Replies: 13
    Last Post: 10-06-2015, 09:12 AM
  5. Replies: 1
    Last Post: 09-13-2011, 01:52 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