Results 1 to 2 of 2
  1. #1
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134

    Retrieve total hours for a project


    Dear all ,
    I have a form which i should fill all the data related to a specific project (StartDate,EndDate,Duration,RemainingHours , Bla bla bla )
    now the problem is in the remaining hours , the equation of remaining hours should be Assigned Hours ( Given already ) - Calculated hours ( here is the problem )
    How can i calculate total hours for a project for all users till current date ??

    the question in another way would be : How can i retrieve totals from report and insert it in a calculated field in a query or form ?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    You're NOT supposed to update calculated fields to a table.
    you sum the hours in a query.

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

Similar Threads

  1. Replies: 4
    Last Post: 09-03-2014, 09:48 AM
  2. Replies: 6
    Last Post: 02-18-2014, 05:32 PM
  3. Overall Total of Hours & Minutes in Report
    By StevenCV in forum Reports
    Replies: 1
    Last Post: 02-27-2012, 10:48 AM
  4. Replies: 6
    Last Post: 12-02-2010, 06:07 PM
  5. Replies: 2
    Last Post: 07-20-2010, 11:02 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