Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-02-2011, 07:00 AM   #1
asif pasha
Newly Registered User
 
Join Date: Jan 2010
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
asif pasha is on a distinguished road
Question Attendance Tracker

Hi all,

I am thinking to develop a tracker which will track the attendance on each day.

My fields are : Emp Id, Name, Sup Name, date1, date2, date3 ....

Where date1, date2, date3... are the current dates which will generate on a daily basis and modify the table. The row are constant unless a new employee joins.

My question is, how to hide all the past days. A form or a query should show only data which display for current day only or it should show the last coloum with couple of coloum before to it.

for ex : Emp Id, Name, dateN (Last date)

Please note :The date is in Coloum not in the row.

Thanks in advance, your help would really require on this, as i cant proceed further.

asif pasha is offline   Reply With Quote
Old 06-02-2011, 07:05 AM   #2
spikepl
Eledittingent Beliped
 
spikepl's Avatar
 
Join Date: Nov 2010
Location: San Serriffe
Posts: 6,144
Thanks: 77
Thanked 980 Times in 958 Posts
spikepl is a jewel in the rough spikepl is a jewel in the rough spikepl is a jewel in the rough
Re: Attendance Tracker

You may want to check some suitable model here: http://www.databaseanswers.org/data_models/

Putting the dates in separate columns is not a good idea: it denormalizes the data, and causes lots of grief further down the road.

Later, you can choose to display data, organized by employee and dates, but that is not how it should be stored.
spikepl is offline   Reply With Quote
Old 06-02-2011, 07:06 AM   #3
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,810 Times in 1,573 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Attendance Tracker

1. You need to learn about NORMALIZATION. You do NOT use a structure where you have repeating fields (i.e. Date1, Date2, Date3, etc.).
Read this about normalization:
http://support.microsoft.com/kb/283878

2. In a properly designed database you almost never need to add new fields to a table.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 06-02-2011, 07:32 AM   #4
asif pasha
Newly Registered User
 
Join Date: Jan 2010
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
asif pasha is on a distinguished road
Question Re: Attendance Tracker

Thanks for the reply,
I do understand creating the no of coloums is not a better idea, but the attendance needs to be captured on a daily basis, if i provide the dates in the row then it will not only increase the no of items, also create a double work for me to go on a daily basis and update the employee details for current date.

Please let me know your thoughts.


If anyone have any model of attendance tracker created in access 97, please forward.

Thanks
asif pasha is offline   Reply With Quote
Old 06-02-2011, 07:39 AM   #5
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,810 Times in 1,573 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Attendance Tracker

Quote:
Originally Posted by asif pasha View Post
Thanks for the reply,
I do understand creating the no of coloums is not a better idea, but the attendance needs to be captured on a daily basis, if i provide the dates in the row then it will not only increase the no of items,
also create a double work for me to go on a daily basis and update the employee details for current date.
The number of items (rows) is not as important as avoiding repeating fields. It is much harder to get meaningful data back out if you do it the way you are proposing. You can simply set up the form for entering the data to have the current date as a default so if you check a box for "HERE" then it will add the date for you.

If you put the data in the way you are proposing - how do you propose to report out, for example, the number of days of attendance? Or calculate the days missed? It would be almost impossible with repeating fields. So, unless you are planning on just doing this database up with the intent of putting data in and never pulling any information as to what data was input, then you need to not use repeating fields.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Yearly Attendance Tracker/Calendar cmcgill General 85 11-15-2017 03:38 AM
Incident Tracker suggestions user9876 Forms 3 12-16-2008 06:56 AM
Help with Tracker cooh23 Tables 8 12-11-2007 01:36 PM
User tracker 31si General 1 02-15-2007 10:21 AM
[SOLVED] Financial Tracker dnnymak Tables 4 11-04-2005 08:03 PM




All times are GMT -8. The time now is 04:10 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World