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

    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
    Location
    Steamboat Springs
    Posts
    2,529
    Look at this link on Allen Browne's site.

    http://allenbrowne.com/subquery-01.html

    Alan

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