Payroll and attendance

[Tia]

Dear All,
I have an access file for the employees attendance.
The main Table Includes all year long attendance.
how can i create a query that will sort them based on a specific dates
gives the total working hours and days along with their annual leave
for each employee for a specific month.
I am thinking abot creating multiple queries. One query for each
month. Example from 25/11/2009 till 24/01/2010

Thank you in advance

 

[Jerry Whittle]

You can do grouping and sorting in a Report bases on number of days or weeks.

Are your monthly pay periods something like every 28 days; start on the 25th
of each month; or something arbitrary?

One possiblitity is to create a table of pay periods and use it to sort and
group.

PayPeriod PP_Start PP_End
11 25/11/2009 25/12/2009
12 25/12/2009 25/01/2010

And so on. You could use this table to assign a pay period to a date when
using a query or during input in a form.

Unfortunately you need to be careful when using the DD/MM/YYYY format. SQL
statements and queries work better with MM/DD/YYYY as they are based on an
ANSI standard. Guess what the A in ANSI means.....