Check in out (1 Viewer)

[syedadnan]

I have a table from time machine i am having two fields, Emid which is unique employee ID, Adate a date coming from machine in general date format,

what i want that the employees are checking in out several times in a day i want a query to show IN as minimum time with respect to each day and same as maximum as OUT for each day

 

[plog]

Sounds pretty simple. What have you tried? Where are you getting hung up?

 

[Vassago]

You should be able to use the Min and Max functions to accomplish this.

https://support.office.com/en-us/article/Min-Max-Functions-6636B171-56B9-434D-ADFD-E1B2A5317B58

You would need to include a column for your EMID and one that grabs just the date of your timestamp field to grab the min and max of each EMID and date. There are multiple ways to strip just the date using FORMAT or INT.