Results 1 to 2 of 2
  1. #1
    Graceyu12 is offline Novice
    Windows XP Access 2000
    Join Date
    Mar 2011
    Posts
    1

    How to sum time in Access Report

    Hello first time here!

    I need help on summing these time in Access (2000 format) Report.
    I realized when i used the wizard to upload the data from query to report, the report doesn't even give me to Summary option on all fields with this Time (HH:MM:SS) format.

    The original data from table are actually in seconds; I converted them into hh:mm:ss in query; Unfortunately these time cannot be "Sum" in the report.

    I tried this one but it's not working.
    =Format(Sum([Time]/3600),"00") & ":" & Format(Sum([Time] Mod 3600)/60 Mod 60,"00") & ":" & Format(Sum([Time] Mod 60) Mod 60,"00")
    Time4:49:054:35:055:13:055:51:064:26:046:28:067:06:076:52:070:33:014:26:040:00:006:28:064:33:052:03:024:46:056:14:066:50:07

    Can somebody please help? My boss needs to see details with summary so I need to use the report.

    Thanks!!
    Grace

  2. #2
    SteveF is offline Generally AccessAble
    Windows XP Access 2010 32bit
    Join Date
    Nov 2010
    Location
    Fourth Corner
    Posts
    123
    Just a quick thought here:

    - Add another column to your query, which just reports the raw unformatted seconds from the table.
    - Add a control to the detail level of the report which "shows" the seconds (but set its visible property = False so it doesn't display on the report).
    - Sum and format this control in the report's footer, this time make it visible.

    Untested and off the top of my head, but it might work!

    Steve

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

Similar Threads

  1. Replies: 2
    Last Post: 12-23-2010, 09:11 AM
  2. Filter Report by Time
    By Tyork in forum Reports
    Replies: 4
    Last Post: 11-11-2010, 01:17 PM
  3. Replies: 1
    Last Post: 11-05-2010, 03:48 PM
  4. Time Spent on Activities Report
    By avarusbrightfyre in forum Reports
    Replies: 1
    Last Post: 10-14-2010, 05:02 PM
  5. Replies: 1
    Last Post: 12-09-2005, 09:16 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