Results 1 to 2 of 2
  1. #1
    DenkoB is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    1

    I need the help of experts.

    Hi,
    In access I have a table in which entries every (importfrm excel) day for information of workers.
    I need to get a table from the data above for every worker in a month total hours. Does somebody can help e with this.


    Sorry th English is not my natural language so excuse for the mistakes

  2. #2
    blacksaibot is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    34
    Well I can't understand any of your column titles... so I'm not sure what each stand for.

    Since English is not your native tongue, I will try to explain best I can.



    Use Query Design, and add which columns you want to see.

    To get the total hours you have to use the SUM function and put a constraint to only add the hours that were used during a certain time frame.

    In a query criteria field, to get a date range us this:

    >= 1/1/2010 And 1/31/2010

    If you put that in the Criteria field of a query, and the column is a Date/Time datatype, it will know only to look for records that were between and include the 1st of January to the 31st of January.

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

Similar Threads

  1. HELP PLEASE (Experts Prefrably)
    By NickyThorne in forum Access
    Replies: 1
    Last Post: 01-06-2009, 09:21 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