Hi all, I m working on this table
emp date job hours a 01/01/2014 1 1 b 02/01/2014 1 2 c 02/01/2014 2 1 a 04/01/2014 1 4 b 02/01/2014 2 1 c 04/01/2014 2 3 - Each line records the hours worked on a job by specific emp on a date,
- On odd number dates only job1 can be chose,
- On even number dates emp can choose either job or both job1 and job2, each line record will only show time for 1 job even both jobs are worked.
- No work no record
- there is no pattern of emp or date in above listing
Expecting the following table as result
emp date job1 job2 a 01/01/2014 1 x a 04/01/2014 4 b 02/01/2014 2 1 c 02/01/2014 1 c 04/01/2014 3
since 01/01/2014 is an odd number date so job2 didn't exist, the table has to show an "x" in job2 on that date, even number date with no hours recorded will be left blank.
emp b has 2 lines of hours works and will be summed as 1 line.
records of all emps will be listed by their names sorted and then dates that worked in Ascending orders
Please help.