Results 1 to 4 of 4
  1. #1
    Daud Engr is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2022
    Posts
    1

    Post Calculating currecnt Record with previous Record

    I am using a Db for calcualting pension. Pension is admissible on gross pension and then increases are added in gross pension. Every increase (percentage) is added in previous record and shown in current record. I am attaching the db as well illustrated the same as under:
    1. Gross Pension : 660

    Increase in pension 2017 10% 726 10% of 660 and plus 660
    Increase in Pension 2018 15% 835 15% of 726 plus 726
    Increase in Pension 2019 10% 918
    Attached Files Attached Files
    Last edited by Daud Engr; 09-17-2022 at 10:55 AM. Reason: 2018 increase % correction

  2. #2
    xps35's Avatar
    xps35 is online now Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    229

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Pulling value from a previous record is tricky enough without calculating a percentage increase as well. For a start, review http://allenbrowne.com/subquery-01.html#AnotherRecord

    But you don't want to pull a value that actual exists in table, you want to pull a calculated result from a query. AFAIK, this sort of "chained calculation" isn't really feasible in Access query with a custom function.
    Last edited by June7; 09-18-2022 at 10:30 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    arnelgp is offline Novice
    Windows 11 Access 2007
    Join Date
    Apr 2020
    Location
    Philippines
    Posts
    2
    Quote Originally Posted by Daud Engr View Post
    I am using a Db for calcualting pension. Pension is admissible on gross pension and then increases are added in gross pension. Every increase (percentage) is added in previous record and shown in current record. I am attaching the db as well illustrated the same as under:
    1. Gross Pension : 660

    Increase in pension 2017 10% 726 10% of 660 and plus 660
    Increase in Pension 2018 15% 835 15% of 726 plus 726
    Increase in Pension 2019 10% 918
    try your Report now.
    this is also Cross answer here: Calculate previous record in current Record | Access World Forums (access-programmers.co.uk)
    Attached Files Attached Files

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

Similar Threads

  1. Replies: 1
    Last Post: 12-15-2018, 09:11 AM
  2. Replies: 17
    Last Post: 10-17-2016, 09:21 AM
  3. Replies: 1
    Last Post: 04-11-2015, 10:31 AM
  4. Replies: 3
    Last Post: 09-19-2014, 08:22 AM
  5. Replies: 8
    Last Post: 07-06-2013, 05:13 PM

Tags for this Thread

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