Timesheet problem

[vincentsp]

Hi all,



I have made a timesheet layout using a form where I can select employees from a Table and select the project they have worked on from my other Table. Besides the project and employee i'm able to fill in their start/stop time for travel, work and breaks.
In a query i'm able to calculate the total time spent per project.

Because one employee works on several projects per day I'm having multiple records per day per employee.

Is there a simple and fast way to print a daily timesheet per employee without changing the query or having one query per person.

Because everybody fills in their one timesheet it should be somewhat userfriendly.

I hope this all makes some sense...

[June7]

Printing timesheet is a report. You want a timesheet printed for all employees? Construct the report so each employee record prints on separate page of report. If you want to allow each employee to print only their sheet, then pass filter criteria to the report. Select EmployeeID from combobox on form and reference the combobox.

DoCmd.OpenReport "Timesheet", , , "EmployeeID=" & Me.cbxEmpID