I gang

Calculate days off table - Repost

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.

Evner: Microsoft Access

Se mere: i am sick of it, spreadsheet holidays, saturday sunday, able calculate, access database track days, sample access project employee database, range table, access track dates, access database track dates, track dates access database, spreadsheet calculate, calculate day time table, calculate date date, calculate days, calculate day, database project access sample, count days dates, calculate date, turn spreadsheet database, calculate time, days dates, calculate date difference days using javascript, excel vba macro calculate business days, calculate dates, can script gets select data table days

Om arbejdsgiveren:
( 0 bedømmelser ) Cebu City, Philippines

Projekt ID: #6042291

Tildelt til:


Hired by the Employer

$30 USD på 1 dag
(0 bedømmelser)