Robertomac
New member
- Local time
- Today, 23:57
- Joined
- May 4, 2006
- Messages
- 8
I have built a database to log ski instructors for our company - recruitment, employment etc.
For each week in resort, I need to create reports that show Instructors Arriving, Instructors Leaving, Instructors Staying, Instructors Moving. I have two main tables that this information will come from, tblInstructorDetails and tblEmploymentRecord.
A new record is created in tblEmploymentRecord for each week an instructor works, so if an instructor works for three consecutive weeks, this is treated as three employments.
Is it possible to create a query that will check whether the instructor has worked the previous week, a query that will check if they are working the following week and a query to check whether they are working the following week but are changing resort? The query needs to run by the departure date. The departure dates are predetermined for the season. From these queries I can obviously create the necessary reports.
I have the database in Access 2003 and if anyone would like to take an actual look at it if they think they can help, I will be glad to email it to them.
Thanks,
Rob
For each week in resort, I need to create reports that show Instructors Arriving, Instructors Leaving, Instructors Staying, Instructors Moving. I have two main tables that this information will come from, tblInstructorDetails and tblEmploymentRecord.
A new record is created in tblEmploymentRecord for each week an instructor works, so if an instructor works for three consecutive weeks, this is treated as three employments.
Is it possible to create a query that will check whether the instructor has worked the previous week, a query that will check if they are working the following week and a query to check whether they are working the following week but are changing resort? The query needs to run by the departure date. The departure dates are predetermined for the season. From these queries I can obviously create the necessary reports.
I have the database in Access 2003 and if anyone would like to take an actual look at it if they think they can help, I will be glad to email it to them.
Thanks,
Rob
