If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Attendance database setup
I am creating an attendance database for my company.
There are 19 different departments in the company and each manager tallies his/her own employee attendances. I had a spreadsheet set up, but it wasn't on a rolling calendar basis. Then, I was going to have the managers delete old months, but that would most likely mess with the formulas. So the new spreadsheet needs to be on a rolling calendar basis, so that when a new month comes up, the previous month from last year will drop off in calculations. My file has three worksheets, one titled "Summary", one titled "Details" and the last "Setup". The Summary page should tally the total absences from the year for each employee. It serves as a quick view. The Details page is where Managers enter information about each individual employee, each day they are late, or don't show up for work. What I would like to do on the set-up page is to create a reference start date, so the Details page can reference this and add 365 days...and sum the number of absences within that range. I don't know how to do this. How should the sheets be set up. Can someone please help? Thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I setup an interactively editable database? | Hunt4868 | New Users | 2 | January 13th, 2006 03:08 AM |
Report based on rst in other database | swedbera | Setting Up & Running Reports | 5 | October 6th, 2005 11:41 AM |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |
What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |
Office XP | Ed Lester | Setup, Installing & Configuration | 1 | May 27th, 2004 09:30 AM |