I gang

Calculate days off table

I currently have a database, in Access, which keeps track of employee's days off. I would like to be able to calculate the total days taken by each employee. The current database has three tables, Dates, Names and DaysExcluded.

The Dates table lists the date range an employee has had off, note that if the EndDate is empty, then it assumed that they only took 1 day off, as well as listing if the day was approved.

The Employee table lists each employee's name and department.

The DaysExcluded lists the dates that shouldn't count towards days off, as they are public holidays.

I would like a table called Result that lists, EmployeeID, FirstName, LastName, Department, DaysApproved and DaysNotApproved. Please note that only weekdays should be counted as a day off, i.e. if an employee is off sick Friday, Saturday, Sunday and Monday, then it will only count as 2 days off.

I have attached a spreadsheet which lists three sample tables and how the results should look.

Please note that I am looking for a quick turn around time on this project.

Færdigheder: Microsoft Access, SQL

Se mere: calculate days, i am sick of it, spreadsheet holidays, saturday sunday, able calculate, access sql calculate, employee access, access database track days, sample access project employee database, access database track time, track time access database, employee database access, access database track date, access employee database, sql employee database, sql database spreadsheet, range table, employee database sql, sql microsoft access project, sql spreadsheet, employee time sql, access track dates, employee access database, empty access, access database track dates

Om arbejdsgiveren:
( 6 bedømmelser ) Australia

Projekt-ID: #6040571

Tildelt til:

NourElDeen

Dear Sir, I'm Expert at access, and interested in doing your project. Kind Regards, NourElDeen

$29 AUD på 1 dag
(51 bedømmelser)
4.8

25 freelancere byder i gennemsnit $29 for dette job

Prashantskin

[url removed, login to view] I have gone through your project requirements and the excel file. I will develop your function and query in Access. I have developed a demo to show you.. But I can not attach it at present. Please reply t Mere

$30 AUD på 1 dag
(490 bedømmelser)
7.1
expertcoder1vw

I am an expert Access / VBA / SQL developer and am interested in working on this project. I can deliver your Access database with the required leave-days report within 3 days or less. I may do the work using VBA Mere

$160 AUD in 5 dage
(41 bedømmelser)
5.8
finecodervw

Hi, Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010 projects both big and small using MS Access as a front end as well as back end. I Mere

$30 AUD på 1 dag
(62 bedømmelser)
5.7
customizedata

I have downloaded the attached excel sheet. I will make a table "Result" that will only count weekdays as a day off, I will make a query in Ms access when executed will fill the Results table with the off days. Please Mere

$30 AUD in 0 dage
(71 bedømmelser)
5.6
mail2vimalarora

Hi, I have gone through details of your project and feel comfortable in taking it forward for completion in a short time of 1 day. I have worked on several MS Access projects earlier of various complexities and can Mere

$30 AUD på 1 dag
(31 bedømmelser)
4.9
abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database Mere

$64 AUD in 3 dage
(12 bedømmelser)
4.9
acronymsolutions

Hi, I have gone through your requirements and attachment as well.I am a DBA at CMM5 Level company since August 2010.I am working on MySql,SQL,MS Access,Oracle database, I can do your job confidently. I am very much Int Mere

$50 AUD på 1 dag
(8 bedømmelser)
3.7
swarm22

Hello, I have +4 year experiences in database development. I am able to do this. For ms access u can see my job profile. Thanks & Regards HGDUmaswala

$30 AUD på 1 dag
(4 bedømmelser)
3.0
hinahanif15

Greetings, I am a BS-CS graduate, thus I am familiar with MS-Access and making queries accordingly. The work will be done by Sunday evening. Hoping to hear soon from you.

$30 AUD på 1 dag
(2 bedømmelser)
1.9
ghsoftlab

Dear, I reviewed specification You gave, I have experience in this type of projects, so I think I can finish it. I can assure You that, if You choose me, the project will be done in specified time frame and it will m Mere

$20 AUD in 3 dage
(0 bedømmelser)
0.0
shanigupta

i will do your work in less than a day. you will be satisfied with the effort provided from my end. hope we will do work together.

$15 AUD på 1 dag
(0 bedømmelser)
0.0
HossamElDine

Hello i'm looking forward to work with you i did many projects like this before i started working , i will send you the initial design of DB the only remaining thing is the view that will get you the results Mere

$15 AUD på 1 dag
(0 bedømmelser)
0.0
nimesh28

I have automated a lot of similar projects like this in my career of over 10 years. I have a fair idea of the work and can deliver it the same or max next day. Looking forward to hear from you. Please read through m Mere

$30 AUD på 1 dag
(0 bedømmelser)
0.0
veerasenareddy

Hi There, I can work on this and deliver it one day. I have 2 quick questions if you can clarify. 1) are you looking for date range approach to display days off or just a quick result with days approved / not approv Mere

$30 AUD på 1 dag
(0 bedømmelser)
0.0
sakthimpwork

I have similar experience this kind of work and good knowledge in ms access. more over i am a senior software developer for Microsoft technologies.

$25 AUD på 1 dag
(0 bedømmelser)
0.0
mingzixian523

Hello, sir. I have enough experience in SQL. I'm ready to start now. Thanks. Regards.

$28 AUD på 1 dag
(0 bedømmelser)
0.0
suvajitmajumder

I have working in SQL and PL/SQL for over 3years. I can provide you a script that can perform the job that you want.

$25 AUD på 1 dag
(0 bedømmelser)
0.0
bsaipavankumar

I have been working on different SQL platforms for the past 6years. I worked on MS SQL , Oracle and Teradata. I worked on different data warehousing projects and I got results for problems like these many a times. I am Mere

$25 AUD på 1 dag
(0 bedømmelser)
0.0
jikkuJacob

A proposal has not yet been provided

$30 AUD in 2 dage
(0 bedømmelser)
0.0
zakirahmouni

A proposal has not yet been provided

$24 AUD på 1 dag
(0 bedømmelser)
0.0