A
Aberdeen123
Hi i hope someone can help:
I am trying to create a report which lists the hours worked by al
employees for the previous 17 weeks.
If for any reason one of the weeks returns a null or 0 value this wee
(for that employee only) has to be discarded and the next i.e 18th wee
has to be used and so on.
Can anyone help with regards to how i could extract this data and the
display it on a report.
I have a Staff table
I have a TimeSheetLines table which has a field weekending date an
foreign key StaffI
I am trying to create a report which lists the hours worked by al
employees for the previous 17 weeks.
If for any reason one of the weeks returns a null or 0 value this wee
(for that employee only) has to be discarded and the next i.e 18th wee
has to be used and so on.
Can anyone help with regards to how i could extract this data and the
display it on a report.
I have a Staff table
I have a TimeSheetLines table which has a field weekending date an
foreign key StaffI