Report Layout Headache

[DBL]

Hi

I'm trying to produce a time sheet list which shows all the hours worked in a specified time frame - split into days. The problem I'm having is I want to view all the staff - even if they haven't submitted a timesheet but whenever I run the query it only shows me those with a timesheet for the day. This is what I would like.

Name Clock No Hours
18/02/09
Employee1 1 7.5
Employee2 2 5
Employee3 3

19/02/09
Employee1 1 6
Employee2 2
Employee3 3 5

Any suggestions?

 

[Dennisk]

you require Left Join in your query.
Ensure the link is 'Include all records from Your StaffTable and only those records from yourOtherTable where the key is equal'

 

[DBL]

Tried that too but still can't get them to include those missing a timesheet.

 

[wiklendt]

dennisk's suggestion should work. perhaps you need to give some more detail of your query design.

 

[gemma-the-husky]

dennis (and wiklendt) is correct - if you are doing it in the visual query designer then

join the tables in your query
then select the link form the employees table to the hours table
right click and select jointype
select include all employees etc.

obviously you need to group this by employee, by date

this will then include all employees, whether or not they have time sheets