Time In Time Out Attendance

[davies107]

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. Form 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

 

[pr2-eugin]

You can create the Query like,

SELECT yourTableName.[ID Num], yourTableName.[Name], yourTableName.[Time In],
yourTableName.[Time Out], yourTableName.[Total],[COLOR=Red] [B](yourTableName.[Total] - 9) As Difference[/B][/COLOR]
FROM yourTableName;

 

[davies107]

but, is it possible that the entries will just be loaded to access database? because no data entry is involved here, there is other tool to get the Time In and Time Out.

 

[pr2-eugin]

This is not data entry. This is a Query that your report will base off. No, excel import will not be able to calculate this for you, neither should you store this.

 

[davies107]

so what can u advice? right now, the database is not created yet. im still getting ideas on how to do it.

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.

if it cant feed into the database, what should be the ebst option? copy paste into the Table? then save a generated report in the pc drive, then delete again for the next time in time out batches.