Calculate days off table

$10-30 AUD

Opravljeno

Objavljeno

pred skoraj 10 leti

$10-30 AUD

Plačilo ob dostavi

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.

Microsoft Access

SQL

ID projekta: 6040571

Več o projektu

25 ponudb

Projekt na daljavo

Aktivno pred 10 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@NourElDeen

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

$29 AUD v 1 dnevu

5,0

(51 ocen)

4,8

25 freelancerjev je oddalo ponudbo s povprečno vrednostjo $29 AUD za to delo

@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 or Access queries / built-in functions. Thanks for considering my bid. Bests, Larry

$160 AUD v 5 dneh

5,0

(41 ocen)

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 have worked on Forms, Queries, Modules, Reports, Sub Reports, Macros, Switch Board Manager, Linked Table Manager etc. With the kind of experience I am having I can assure you of quality work first time and on time On this highly competitive site I fully understand how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder

$30 AUD v 1 dnevu

4,4

(62 ocen)

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 provide existing Ms access database and PM me so that we could wrap it up fast. I will do work very fast

$30 AUD v 0 dnevu

4,8

(71 ocen)

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 provide you required solution. Waiting for your response to talk further in detail on the project and start the work. Thanks.

$30 AUD v 1 dnevu

4,9

(31 ocen)

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 (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Access and VBA to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, i am persuaded to give you High quality of work delivery withing budget and time Best regards,

$64 AUD v 3 dneh

5,0

(12 ocen)

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 Interested to do your work,Please revert me if you have any concern .I am ready to start now.

$50 AUD v 1 dnevu

3,8

(8 ocen)

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 v 1 dnevu

4,9

(4 ocen)

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 v 1 dnevu

5,0

(2 ocen)

1,9

@mingzixian523

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

$28 AUD v 1 dnevu

0,0

(0 ocen)

0,0

@rageshmenon

hey, you will e provided with quality data and you can count on me for your job at any time. Works for 24 hours.. Feel Free to hire me.

$25 AUD v 1 dnevu

0,0

(0 ocen)

0,0

@sushma01sng

A proposal has not yet been provided

$25 AUD v 1 dnevu

0,0

(0 ocen)

0,0

@MariaLR

Good day, I would like to do this job for you. Would you provide us with the Access Database? What version you are using? Regards, MariaLR

$25 AUD v 1 dnevu

0,0

(0 ocen)

0,0

@rahulgupta555

Dear Sir, I was excited when I saw your job postings online for Microsoft Access and SQL person. I have three years of Microsoft Access and SQL experience, and I have performed all of the duties listed in your job description. I type 42 wpm with almost 100% accuracy, and my employers have praised me for my focus, speed, accuracy, and professionalism. I hope these are qualities you look for in your data entry employees. I am looking forward to discuss you further on chat where we can discuss the open positions in more detail, and you can ask any questions you may have. Please schedule a time to meet. Thank you I look forward to meeting you. Sincerely, Rahul Gupta

$35 AUD v 1 dnevu

0,0

(0 ocen)

0,0

@zakirahmouni

A proposal has not yet been provided

$24 AUD v 1 dnevu

0,0

(0 ocen)

0,0

@jikkuJacob

A proposal has not yet been provided

$30 AUD v 2 dneh

0,0

(0 ocen)

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 good at using MS Access and I get you the desired result in 1 business day. I am sure that I can give the desired result with atmost accuracy.

$25 AUD v 1 dnevu

0,0

(0 ocen)

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 v 1 dnevu

0,0

(0 ocen)

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 v 1 dnevu

0,0

(0 ocen)

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 approved 2) are you looking for Access table/query or SQL query/table Thanks, Veeru

$30 AUD v 1 dnevu

0,0

(0 ocen)

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 using aggregation functions i'm new here but skilled , check my profile looking for your satisfaction and good rating thats why my fee is small best regards Hossam

$15 AUD v 1 dnevu