Results 1 to 2 of 2
  1. #1
    denileigh is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2006
    Posts
    3

    Report with 2 sets of Dates

    Hello all,

    I have a payroll report that currently works ok however we are moving to bi-weekly pay periods but time is still paid weekly. Basically what I need will look like this for example

    Employee Date Reg Hours OT Hours Other Hours Daily Total

    Week 1: January 1-7, 2012
    John Doe 1/1/12 8.0 1.5 0.0 9.5
    John Doe 1/2/12 8.0 1.5 0.0 9.5
    John Doe 1/3/12 8.0 1.5 0.0 9.5
    John Doe 1/4/12 8.0 1.5 0.0 9.5 etc

    Week 2: January 8-14, 2012
    John Doe 1/5/12 8.0 1.5 0.0 9.5
    John Doe 1/6/12 8.0 1.5 0.0 9.5
    John Doe 1/7/12 8.0 1.5 0.0 9.5
    John Doe 1/8/12 8.0 1.5 0.0 9.5 etc



    Week 1 Totals 32.0 6.0 0.0 38.0
    Week 2 Totals 32.0 6.0 0.0 38.0
    PAY PERIOD TOTAL 64.0 12.0 0.0 72.0

    I have a report that runs but I can't figure out how to get it to split the weeks and then total them. Can anyone help?

    Thanks so much,
    Dianne

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You might want to look at the datepart() function which has an option to get the week number from the date. You can use this as a grouping level on your report.

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

Similar Threads

  1. Between and End Dates on Report
    By BLD21 in forum Reports
    Replies: 5
    Last Post: 05-08-2011, 04:32 PM
  2. Between Dates Report Problem
    By aamer in forum Access
    Replies: 4
    Last Post: 12-02-2010, 01:00 PM
  3. sets of queries
    By nashr1928 in forum Queries
    Replies: 2
    Last Post: 08-03-2010, 02:18 PM
  4. Filtering Report with between dates
    By patrickmcdiver in forum Reports
    Replies: 3
    Last Post: 02-22-2010, 12:11 PM
  5. Need report to show dates
    By Brian62 in forum Reports
    Replies: 2
    Last Post: 11-20-2009, 12:05 PM

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