Results 1 to 2 of 2
  1. #1
    kpierro is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    3

    Getting a total for ALL records

    I have an access database where we record hours worked for each project that we are working on (basically a timesheet database, which I have reports that will show how many hours reported to each project).
    I have run into a wall. I have the total hours per person that has been worked on the project for that week, and the total hours for the week, but am unable to figure out how to get the total accumulated hours worked on the project since inception (the grand total hours spent on the project).
    Is there an easy way to do this, or what am I missing?
    I have a table for Straight Time and Over Time hours being reported, so those would need to be added together at the end.


    (I'd attach the database, but we are pretty locked down here where I work)

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    yes, sum the total hrs for the project. Don't limit to a person.

    select sum(straitTime), sum(OvtTime) from table where [project]='MyProject'

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

Similar Threads

  1. Replies: 2
    Last Post: 05-25-2015, 05:02 AM
  2. Replies: 1
    Last Post: 01-24-2013, 05:50 PM
  3. Replies: 7
    Last Post: 09-23-2011, 08:31 AM
  4. stuck on expression for total query records
    By pacer31 in forum Queries
    Replies: 3
    Last Post: 07-04-2011, 11:30 AM
  5. Total records printed
    By LesleyA in forum Queries
    Replies: 3
    Last Post: 08-04-2008, 03:53 AM

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