N
Nick X
Hi all,
I would like to duplicate the excel spreadsheet we use to track our two week
pay periods using Access report. I just can't figure out how to get the
dates to flow into columns like the example below (if it survives). What I
would like is to have a row for the day of the week (2 weeks Mon-Sun), a row
for the date (15, 16, 17, etc) and to have the columns populate with the
hours based on the job name.
All help would be greatly appreciated!
Thanks,
Nick X
Pay Period:12
Name
oe, John From:May 15, 2006 To:May 28, 2006
Job|ActivityCode|Fund|M|T|W|Th|F|S|Su|M|T|W|Th|F|S|Su
15 16 17 18 19 20 21 22 23 24 25 26 27 28|Total
OffAdm |11| 10000 |0.5 0.5 1.0 2.0
Meeting| 99| 10000 |3.0 1.0 4.0 8.0
DbAdm |11| 22111 |3.0 5.0 8.0
TOTAL 80.0
________________ _________________ Employee Signature Supervisor
Signature
I would like to duplicate the excel spreadsheet we use to track our two week
pay periods using Access report. I just can't figure out how to get the
dates to flow into columns like the example below (if it survives). What I
would like is to have a row for the day of the week (2 weeks Mon-Sun), a row
for the date (15, 16, 17, etc) and to have the columns populate with the
hours based on the job name.
All help would be greatly appreciated!
Thanks,
Nick X
Pay Period:12
Name
oe, John From:May 15, 2006 To:May 28, 2006Job|ActivityCode|Fund|M|T|W|Th|F|S|Su|M|T|W|Th|F|S|Su
15 16 17 18 19 20 21 22 23 24 25 26 27 28|Total
OffAdm |11| 10000 |0.5 0.5 1.0 2.0
Meeting| 99| 10000 |3.0 1.0 4.0 8.0
DbAdm |11| 22111 |3.0 5.0 8.0
TOTAL 80.0
________________ _________________ Employee Signature Supervisor
Signature