Time In Time Out Attendance

[gatsby]

Can anyone direct me to a sample database where its about Time In and Time Out Attendance. If not, can anyone give me an idea how to do this?

It will just calculate the difference of Time In Time Out with employees Card Number.

The Time In and Time Out attendance is provided (no data entry), it is generated from other tool. I will just load it from an excel sheet to the access database and it will calculate and generate report. Default should be 9 hours per day, if they wont render 9 hours it will show in Difference column. Report will be like this:

ID Num: | Name: | Time In: | Time Out: | Total |Difference (missing hours)



12345 | Al Smith | 8.00am | 5:00pm | 9 | 0
54321 | Joy Pitt | 8.00am | 4.30pm | 8.30 | -0.30

[June7]

That doesn't look like correct time structure. Is the time values saved into date/type data type?

[gatsby]

actually, i havent started the database yet. im getting ideas first.

what they want me to do is to create a database for time in time out attendance..... the report should have id number, name, time in, time out, total, difference... wherein the time in time out are given or taken from another tool. i will just feed the excel sheet containing the time in time out into the access database to generate a report. its a good idea to feed since access only has 2gb of memory, so this excel sheets are separated from access memory.

[June7]

Only 2GB but depending on the data, that could be millions of records.

Use DateDiff function to calculate difference between start and end date/time values.

[gatsby]

problem here is that , im not an expert with Access. i do research and apply what i researched....

it could be millions of record but if the record is growing everyday, 2GB will be no more. and also, they dont want someone to key-in the time in time out records because a tool has been doing that for us.

[trevor40]

example of db size
repair tracking db 130.000 repairs, 400+ customers. + assosiated data = ~ 120mb
! after compact/repair if you don't then the db can grow and grow...
so for your 2gb youll'd be looking at over 2mill records

[gatsby]

its not possible also to import? excel sheets to Table (time in time out)... they just dont want the data entry job, putting all the time in time out in the access database to generate report.

[June7]

Yes, Access can import from or dynamically link to a spreadsheet.