Results 1 to 2 of 2
  1. #1
    todmac is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    20

    Subtracting from previous record in a report


    Hello,
    I have a report (based on a query) that lists the date, and number of Kilometers at each data entry.
    I want to show how many KM's there are between entries, so I need the most recent entry - the second most recent entry. Then the second most recent entry - the third most recent entry and so on.
    I have played around for a whle now and looked everywhere online, but I am not clear on the easiest way to do this. Help?
    Todmac

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,643
    Not really sure what you want, but for one possibility, review http://allenbrowne.com/subquery-01.html#AnotherRecord

    Or maybe you want a running sum. Textbox in report has a RunningSum property.
    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.

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

Similar Threads

  1. shows previous record on report.....
    By shah1419 in forum Reports
    Replies: 0
    Last Post: 08-28-2013, 02:22 AM
  2. Replies: 5
    Last Post: 07-19-2013, 03:42 PM
  3. Replies: 8
    Last Post: 07-06-2013, 05:13 PM
  4. Replies: 5
    Last Post: 06-16-2013, 05:25 PM
  5. Subtracting aggregate fields in a report
    By ProjectHelp in forum Access
    Replies: 6
    Last Post: 03-21-2012, 10:48 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