Results 1 to 2 of 2
  1. #1
    scubagal is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011

    Calculation Function In A Report

    I created a simple report in Access 2010 that in one column lists the date with a column beside that lists a numeric reading for that date. Now what I need to do is make a calculation that subtracts 1 reading from the previous reading and dispalys it beside of the first date. Example:

    Date Reading 24hr Difference

    11-1-11 123456 333

    11-2-11 123789 174

    11-3-11 123963

    Is this possible? Thanks for any help.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Steamboat Springs
    Look at this link on Allen Browne's site.


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

Similar Threads

  1. Total Calculation, nz function, not working
    By Jojojo in forum Programming
    Replies: 3
    Last Post: 10-10-2011, 02:33 PM
  2. Report Calculation
    By Azeez_Andaman in forum Reports
    Replies: 7
    Last Post: 10-08-2011, 11:58 PM
  3. Calculation in a report
    By jlzags in forum Access
    Replies: 3
    Last Post: 08-25-2011, 01:47 PM
  4. Various Day Calculation Function
    By access_tom in forum Access
    Replies: 6
    Last Post: 10-13-2010, 02:37 PM
  5. Report Calculation
    By thestclair in forum Reports
    Replies: 2
    Last Post: 03-28-2006, 12:23 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 - Senior Forums