Results 1 to 4 of 4
  1. #1
    metokushika is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    19

    Talking Sum up values

    hi


    i have a form
    with a text box
    that says regular hours


    for each employee
    that times in and out,
    it automatically calculates
    the total hours and is put
    on the 'regular hours'



    for each form, this has it but
    my problem is that if i make
    a report out of it, how am
    i supposed to sum up all
    of the given 'regular hours'
    for all the forms that was filled up?
    like say the total forms filled
    up was 5?

    how am i able to sum up
    those 5 text boxes?



    pls help pls help!





  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Do you really need this on a form? Reports are intended for this kind of data manipulation (summary calculations).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    metokushika is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    19
    i will be using a report when i sum up all of what's in the form. but how?




  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Try report Grouping and Sorting functionality. Access Help has guidelines on this. Google: Access 2007 report grouping
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 0
    Last Post: 07-26-2011, 02:03 PM
  2. Yes/No Values
    By maintt in forum Reports
    Replies: 3
    Last Post: 07-19-2010, 05:16 PM
  3. Replies: 8
    Last Post: 05-25-2010, 04:50 AM
  4. Replies: 3
    Last Post: 04-04-2010, 05:26 PM
  5. Replies: 1
    Last Post: 03-27-2010, 06:13 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