Report : Latest Result (2 Viewers)

[eyeseven2014]

Hi Guys!

I have an attendance database and I connect the time attendance machine db to my access db, what i am trying to do is to generate a report that shows the time in and time out for specific date. the type of attendance db is date/time.

Please see the attached screenshot db from attendance machine.

an also some time there is duplicate entry, I need to get the first and the last entry only for specific date.

I hope you can help me.

Thank you guys!

 

[plog]

This SQL will do what you want:

SELECT DateValue([CHECKTIME]) AS CheckDate, Min(TimeValue([CHECKTIME])) AS FirstTime, Max(TimeValue([CHECKTIME])) AS LastTime
FROM YourTableNameHere
GROUP BY DateValue([CHECKTIME]);

 

[eyeseven2014]

Hi Plog! Thank your help.

I am really new in access, but where should i put this sql statement?

 

[plog]

Create a new query, don't add any tables to it, then in the upper left hand corner of Access click on the SQL view and paste it there, then run it.

 

[eyeseven2014]

Create a new query, don't add any tables to it, then in the upper left hand corner of Access click on the SQL view and paste it there, then run it.

Thanks Plog! It helps a lot!

anyway, one more problem here, if the employee did not signout, the max time will be the same as first time.

Thanks again!