Staff Holidays
Hi All,
I need a query to tell me how many staff are on holiday on the same day..here what i have so far.
A query with name, startholsdate,endholsdate, totaldays, etc, etc,,
records showing; employee A books 01/01/06 to 14/01/06 and employee B books 10/01/06 to 24/01/06 C books 01/02/06 to 10/02/06 and so on,
I need to show how many employees are off on what days eg employee A and B are on hols between 10/01/06 and 14/01/06, so only 3 more staff may take days off between the 10th and 14th. I have tried all sorts of calculations but to no avail? can anyone help..
thanks
View Complete Forum Thread with Replies
Related Forum Messages:
Add Staff Photo
Hi everybody, Recently I created a database for staff details in my company and I used OLE Object in Data type to make it. The problem now there are more than 500 employees in the company so it is very difficult to scan one by one photo. Is there any way that once I click on command button photo will be detected from scanner and saved directly in the field instead of doing it manually. Thanks and regards
View Replies !
Staff Schedule - 'how To' Help..
Hi all, I'm relatively new to Access and would like a few pointers... I have been asked by work to create a schedule database. We would like to be able to put in dates and see who's working on that day, pull up an individual and see his/hers rota for a week. Also see if they have meetings, annual leave, sickness etc.... We want it to be a very primitive WFM tool. Is this possible and is it relatively easy? The database doesn't have to create the shifts, they will be imported from Excel.... Which leads me to believe I need to think of it differently to excel... Attached is an excel rota, which would need to be importred - but maybe I need to be think a lot differently. I know thats a big question but any help would be appreciated, or pointers to more resources... Thanks Neil
View Replies !
Another Staff Rota
I am trying to develop a simple staff rota. Simple being a laughable term. :o My staff is task oriented and changes thier tasks daily. I would like to display a monthly schedule in Timebar scheduling format. Similar to the rolling calendar in MS Project. (Tried using project, but tasks are non-repeatable on the same line) I cannot down load 3rp party programs as they are not allowed on our network, and I would also like to tie it into our SharePoint sites. Q. Is there a ActiveX control like the calendar control that can express dates in a time bar style? Q. If there is no easy way (:rolleyes:) then where does the code start to do the calendar peice... Just looking for ideas. Thanks in advance!
View Replies !
Line-manager / Staff Relationship?
Hi all, I'm a bit stuck with a db relationship design. I need to hold information in a staff table about a person's Line-manager. My initial idea was to just have the Staff Table and use the PK of a member who is a Line-manager as a FK in the Line-manager field in the same table for their staff. I then came across a problem. I need to be able to select all the staff under a Line-manager. For example a head of department may have 3 team leaders who each manage 10 staff. I need to know all of them, not just the 3 team leaders who are directly managed by the HoD but their staff as well. As it happens there is no rigidgly defined managment structure per se for this organisation which makes things even more difficult. I assume there is a reasonably standard way of doing this as all organisations have some form of line-manager/staff relationship. Anyone care to enlighten me? Cheers TS
View Replies !
Staff Day To Day Work Times And Payments
i am unsure as to whether this can be acheived in a database.. basically this task is almost calendar like. the company operates 7 days a week. i have a table of company drivers and each has their own driver ID. my user would like to store what time each driver comes into work each day and what time each driver leaves. this needs to be quite flexible however because some days certain drivers wont work, but each day..if a driver has a 'come to work' time then they will for sure have a 'leave work' time. each driver also pays rent to the company once a week. within this calendar like system i would also like to store on what day the driver paid what amount towards their weekly rent. i cant quite imagine how this can be done in a database. but if these kind of applications are common, i would be most grateful for some direction. thank you. one more thing.. i would also need to record during each day what time the driver left and returned from lunch (sometimes our drivers leave for a few hours during lunch time) i want to store this because if they miss a job while they are on an extended lunch break im gonna roast em.
View Replies !
Staff Holiday Request Database
hi, i need to design and build a access database for school where staff for a business could request holidays with there holidays then appearing on sum sort of calendar which can be viewed. does nebody know where i can find an example to help me with my desing? thanx glen
View Replies !
Change Staff Assignment Dynamically
Hi...Newbie here! This might be long, but I want to be clear... I'm working on a database for my agency in which clients are assigned to specific staff through use of a staff id number. For administrative purposes, we have one *generic* client that is not assigned to a specific staff member. However, each staff member must be able to save records for that client under their ID number. Currently, I have a form to create client records that uses cascading combos. In the first combo, the user chooses the staff member. The second combo is then limited to the clients of that staff member. I have set the underlying query up to include the *generic* client in each staff members client list, but I cannot save records for that client. I get an error message that indicates it's because the generic client is not assigned to the staff member. Is there a way to temporarily assign that staff member to the generic client, perhaps some sort of AfterUpdate event that is only triggered when the staff member is chosen in the first combo? Thanks for any help!
View Replies !
Accumulating Holidays
OK Here's the deal: An employee has 0 holiday days in the first year of employment and accumulates 1 holiday day for every 1.2 months worked after the first year of employment. So after 2 years of working the employee is entitled to 10 holiday days, but if the employee only takes 5 holiday days they should be able to accumulate the rest of thier days into their next year. I've added the database that I've created so far, I haven't got too far, and I realize that I will have to create a field in the employee table with the first day of employment. Any help with this would be greatly appreciated.
View Replies !
Query/Update Sales Values For Individual Staff
Hey, I am currently doing an A-level ICT project and seem to be stuck at the first hurdel. My problem being that i wish to update the 'Number of sales' field for all the staff in the 'Staff' table. I have tried serveral queries to count the number of sales, which are in the 'Tickets' table for each and indidual 'Staff ID'. This was suscuessful although i am wondering how to transfer these values into the Staff.[Number of Sales]. Also some staff had the value of 0 so did not come up in results of the querie. Is there any possible solution or is there a more simple way to solve the problem. Many Thanks in advance Dan Parker
View Replies !
Employee Absense/Holidays Database
Hi all, I am stuck where to start and wanted some advise. I want to create a database that captures whether employees are late, sick, holidays etc. So i would have a list of employees, then create a new records in another table to store what type of reason it is, (late, sick, holidays etc.), and then the directors can monitor employee sickness. But what i would to do is to be a bit clever about it though in 2 ways. Against the employee they would have a number of allocated holidays against them, but i just wanted the user to enter the start and end date, and then get access to work out how many holidays days need to be taken off, i.e. it does not included weekends or bank holidays.... Also in the sickness report, work out how many single days where taken on either a Monday or Friday.... Has anyone done or seen an access database that can do this already. I know there is a calendar addin, but i've not used it...
View Replies !
Bank Holidays: Advice Needed
hi i'm trying to build something that knows when to notify someone that they can call a trade, given 1) a callable date 2) a notice period and 3) the relevant cities e.g. ?NotificationDate(#28-jun-2008#,10,"LONY ") 16-06-08 the good news is, i've done it, with this code:- '--------------------------------------------------------------------------------------- ' Procedure : NoficationDate ' Date : 28/03/08 ' Purpose : to calculate the date of notification for an EMTN, given the call date & notice period & cities '--------------------------------------------------------------------------------------- ' Public Function NotificationDate(dtCall As Date, intPeriod As Integer, strSixDigitCities As String) As Date Dim intWorkingDaysBefore As Integer Dim strCities(2) As String Dim dtLoop As Date strCities(0) = Left(strSixDigitCities, 2) strCities(1) = Mid(strSixDigitCities, 3, 2) strCities(2) = Mid(strSixDigitCities, 5, 2) dtLoop = dtCall intWorkingDaysBefore = 0 Do dtLoop = dtLoop - 1 If Left(Format(dtLoop, "ddd"), 1) <> "s" And IsBankHoliday(dtLoop, strCities(0)) = False _ And IsBankHoliday(dtLoop, strCities(1)) = False And IsBankHoliday(dtLoop, strCities(0)) = False Then intWorkingDaysBefore = intWorkingDaysBefore + 1 End If Loop Until intWorkingDaysBefore = intPeriod NotificationDate = dtLoop End Function '--------------------------------------------------------------------------------------- ' Procedure : IsBankHoliday ' Date : 28/03/08 ' Purpose : to see if it's a bank holiday '--------------------------------------------------------------------------------------- ' Public Function IsBankHoliday(dtInput As Date, strCity As String) As Boolean Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT * FROM qry_Tass_All_Hols WHERE CITY = '" & strCity & "' AND HDATE=#" & Format(dtInput, "mm/dd/yyyy") & "#", dbReadOnly) If rs.RecordCount > 0 Then IsBankHoliday = True Else IsBankHoliday = False End If rs.Close Set rs = Nothing End Function BUT it runs like arthritic toad, it makes a minute per execution and i was hoping to scale it up to 4000 records => 2 days of run time :eek: any ideas on how to attack this problem...even guesses appreciated, i can try things out and see if they work thanks in advance
View Replies !
Future Date - Taking W/e & Holidays Into Account
Hey all, I'm designing a query that must calculate a future date based on a recorded date. Unfortunately it's not as simple as just using adddate (unless I was using Excel!). Here's my requirements: Future Date = [StartDate] + 45 business days I am able to take weekends into account, but haven't been able to figure out how to bring holidays into the equation. I have an existing holidays table that I am using for another query within the database (calculates # of business days between 2 existing dates). Hope this makes sense... I've been staring at it all day so I may not be thinking clearly anymore. Any help is greatly appreciated.
View Replies !
|
TRACKER
