Help needed on Selection

[Former Member]

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

[Former Member]

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

[Former Member]

The data should be like this

Emp hrs in the time period YTD

A 10 260

B 0 104

C 45 354

[Former Member]

Still need an answer to these questions

When an employee does not work what is stored in the field 0 or null

What is your select statement currently.

Ian

[Former Member]

Say we take the time period between Jun and Sep and a particular employee has worked in march then 0 will be displayed in the hrs column and the YTD would be the hrs he has worked in that yr upto the end date in the period(for this ex 09/30/2011)

[Former Member]

I know what you are trying to do, but can not offer any suggestions unless you show us your current select statement. This will give some clues as to why March figures are being excluded.

Ian