Time and Attendance Project

[Access_Elic]

Hi Guys,

Currently we a door access and all the data I downloaded from the device is text,

First problem the Time IN datatype is text I want to convert it to DATE/TIME data type and it should be First IN (MIN). I tried the query below I have an error. Syntax Error Missing Operator.

Min(Cdate(Mid(HISTORY.ETIME,1,2) & ":" & Mid(HISTORY.ETIME,3,2)) AS timein

 

[namliam]

You are missing a closing )
Count the number of ( and ) and you will find you are missing a )

 

[namliam]

Since you are only just starting out, let me point you to the Name conventions that one should try and stick to when developing stuff...
http://www.access-programmers.co.uk/forums/showthread.php?t=225837&highlight=name+convention

Please have a look at that and try and keep that in mind while developing your database.

 

[Access_Elic]

Thank you namliam for prompt response, and it worked stupid of me.

I have another question How can I combined two columns Like Transaction Date and Time IN.

 

[namliam]

date and time are the same type date/time... you can store them in one column

Also you can easily combine them by simply adding them:
Date + Time