on 2011 Oct 20 2:33 PM
I have a table in the following format
empl jan feb march apr.......... Dec YTD
in months column the hours worked in that month are displayed and in YTD the whole hrs from a selected date range is being displayed.
Now I have a problem when I select between june and sep the employees who didnt work in that time are not displayed. I want them to be displayed bcoz the YTD hrs still matters.
IS there any way I could get all the employee list there
When an employee does not work what is stored in the field 0 or null
What is your select statement currently.
If you are only interested in June to Sept why do you want YTD figures for employees not working then?
Please give example of data and how you want report to look.
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.