each user has one month record

hi,

im creating a time recording database which is being used by 100 users...everyday each user logs his own start and end time...how can i create a database that would hold up a monthly record for each user? say user1 logs on day1 start and end time...the following day user logs day2 start and end time...the following day user1 logs his start and end time again and so goes the cycle daily...so all in all user1 would have a monthly record of his daily start and end time...how can i accomplish this???

thanks,

stoey

Hi Kirk,

Thanks for your reply...i assumed that you are referring in creating this using excel...but my question refers to the use of microsoft access...any idea how to do that in microsoft access? or do you have a sample database which can help me start with? thanks again

Hello there,

How are you currently tracking them logging in and out? I.E. are they entering their information into a table or a form?

Thanks!

Quite simply, you wouldn't bother. The users just log the times etc in the table and you run a query to get the dates and times per user per month

Originally Posted by rvasquez

Hello there,

How are you currently tracking them logging in and out? I.E. are they entering their information into a table or a form?

Thanks!

hi there,

thanks for replying...yes i am tracking them by logging IN and Logging OUT...so each day a user basically has a set of his log INS and OUTS...and they are using form in entering their time INS and OUTS...

---------- Post added at 12:04 PM ---------- Previous post was at 12:00 PM ----------

Originally Posted by Kyle123

Quite simply, you wouldn't bother. The users just log the times etc in the table and you run a query to get the dates and times per user per month

hi kyle,

thanks for replying as well...user's are using form in entering their time INs and OUTs and these are being stored in a table...uhhmm let's say its August 21, each user has a time IN and OUT for that day...so how can he logged his time IN and OUT for August 22 and so on? I'm not sure how to accomplish this...I dont know how can I create a record like for August 1 to 31 for their time INS and OUT...

Your table would be something like:
User - DateTime In - DateTime Out
User - DateTime In - DateTime Out
User - DateTime In - DateTime Out
User - DateTime In - DateTime Out
User - DateTime In - DateTime Out
User - DateTime In - DateTime Out

Then

PHP Code: 

SELECT * FROM YourTable WHERE User=UserID AND Month(DateTimeIN)=8