Search results

Table ID ---- FirstName ---- Last Name ---- Start Date ---- End Date 01 ---- Peter ---------- Jones --------- 03/12/2008 02 ---- Paul ----------- Bramwell ----- 09/12/2014 03 ---- Bill ------------ Johnson ------- 04/02/2012 --- 03/12/2014 Query ID ---- Staff Member ------------ Start Date...

Right I've been thinking about this for a while now and I can see one fairly easy viable option for it. The staff table holds an ID for the staff member. The time table holds the shifts for the staff member. I have a query that adds their total rota based hours together. The staff table also...

Hmmmm for the purposes of this it would just be to store what a persons rota would be. So it would only be contracted hours. They way I was looking at it was that you would put a start date in for a new staff member and it would work out the holidays based on that start date until the end of the...

So maybe add contract yes/no each time record And start end dates to be added in the staff table?

In regards to the start end dates I just want them to be variable. Then the database will maintain the rest. So if someone leaves before the end of the year I can put that end date in and it'll tell me the amount of holiday entitlement they should have had before leaving or changing their hours.

Sorry bet you wish you'd never replied to this thread lol

Yeah it is. I have a query doing that Sum([Overall Hours]/4) The hours are maintained by a module that tracks the times in and out and returns the total hours minus the deductions.

And 8.75 x 5.6 x (106/366) = 14.191257 hours

Right I'm stuggling to understand what this inline function is doing but I'm impressed with it! What I want to do next is have the option for a variable. So for example if I am working out the leave for a staff member who started after the 1st of april it can work out the days in the year from...

Errrrr yeah thats what I meant lol :eek: Number of days in the year. So for example where you've set the start date up the amount of days until the end date (again default 31/3/whatever year) Cheers

As you can tell I'm very very new to VBA but am learning it slowly :)

How do you get it to count the days. I'm falling short. Was trying the... DateDiff("d", CDate([Default Start Date), dat)

Sorry got it now. Thank you so that gives me the default start date and the count.

Will that give a day count for the financial year or will it see how many days are in an actual year?

Also is there a way of getting the default date to track based on the financial year we are in. So for example when we are in 2018 it will show 01/04/2017 as the default start date?

Hi all, I have a database with shifts in for staff. They have a bunch of times in and times out over a four week period. I have gotten an average weekly amount of hours for each staff member based on this but I need another equasion to work out their leave entitlement. It breaks down like...

It's just to hold the data for the four week rota. All the equations etc are done based on four weeks so no real need to go any further with it. The next step I am trying to do is adding up all the total hours at all locations over 4 weeks which I have done so that I can figure out things like...

Hi, The av etc is now in location and has fuller names. I was thinking that about the tables for weekdays etc but thought I'd be more thorough ha! We have a rolling 4 week rota so basically it goes back to week 1 again. I'll put the days and weeks into the TblTime. Cheers, Paul

Here is an updated version of the table structure with normalisation. I'm just wondering how I can get it to work with the layout of the form.

In terms of the normalisation I would still like the form to have the same lay out as it has. Is there a way of setting it up with the normalised tables in that way. Like... ID - Primary Key StaffID - Foreign Key Location - Foreign Key Day - Foreign Key Time In - Date/Time Time Out - Date/Time...