Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    5

    Calculation


    I have a report that is grouped by 'Job Charge.' Each Job Charge has several records. A single Job Charge grouping may have 1 or more records. Each record has text box representing x number of hours. I'd like to add each Job Charge grouping hours together for a sub-total for that Job Charge. I added a text box under it in the Detail and Footer sections but no luck. I'm not sure of the formula anyway. I used sum([hours]) and something else but nothing. Thanks for the help.

  2. #2
    Join Date
    Apr 2006
    Location
    Manchester UK
    Posts
    11
    The records for each Job Charge header should go in the details section of that group.
    Then assuming your text box is formatted as numeric & not as text & assuming that the name of the text box is 'hours' then

    =Sum([hours])

    in the Job Charge group footer should work.

    Are you getting an error message?

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

Similar Threads

  1. Calculation Help
    By edge5511 in forum Programming
    Replies: 4
    Last Post: 12-18-2015, 11:11 AM
  2. Calculation is off by a few cents...
    By Jule in forum Reports
    Replies: 3
    Last Post: 05-01-2006, 01:06 PM
  3. Report Calculation
    By thestclair in forum Reports
    Replies: 2
    Last Post: 03-28-2006, 12:23 PM
  4. Date Calculation within same fields
    By mslieder in forum Queries
    Replies: 3
    Last Post: 01-26-2006, 10:08 AM
  5. Subform vs main form calculation
    By fadone in forum Forms
    Replies: 17
    Last Post: 12-21-2005, 07:27 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