Payroll Database

[mark123456]

I am creating a database that keeps track of my company's payroll. I am looking to create a query that will be used to generate a report that will give a breakdown of the hours each employee worked per day (for a given time period) and then subtotal the data. All times are stored as numbers and are expressed as portions of 1 hour (6.50 is equal to 6:30).

I would like to make my report look like this:

John Smith July 25, 2009 8.00 17.00 9.00
John Smith July 26, 2009 7.95 17.05 9.10
John Smith 18.10

Mary Carter July 25, 2009 7.99 17.01 9.02
Mary Carter July 26, 2009 8.01 16.99 8.98
Mary Carter 18.00

How can I accomplish this?

Any help is greatly appreciated.

Thanks in Advance,

Mark

 

[PNGBill]

Regarding the subtotal - your report can handle this. just use the query to collect the data on employee and hours.

 

[mark123456]

Thanks so much for your help; how could I subtotal by employee in my report?

I want a report with multiple employees that provides a subtotal for the total hours each employee has worked; all i know how to do is total all of the values included in a column on the report.

Anything anyone could do to point me in the right direction is greatly appreciated.

 

[PNGBill]

You can set the Grouping of a report to include Headers and footers.
These can hold unbound text box controls that can Sum the controls in that group, sub group etc and of course, for the report.

You can do Conditional calculations as well.

One Report could show each Employee, as a Group and in the Report Footer, have the grand totals.
You could have depts also.

A second report will give you the one page showing all Employees with their respective Hours, etc.

You can set the two reports to run consecutively by vba code or macro so as print job, they appear as one.

You can have Reports and Sub Reports, as you have Forms and Sub Forms. This may allow the two reports to be combined.

 

[mark123456]

Thanks so much for all of your help, I managed to get the report and query behaving exactly like I wanted them to.