Regards,
I have a table name Data_Mac where is storing employees daily time-in and time-out i have some duplicates or multiple entries there for every employee what i want is that query to eliminate all just pick day first or say minimum time as time in and day last say maximum time as time out with date all these date fields are set to short time. example is ;
I have a table name Data_Mac where is storing employees daily time-in and time-out i have some duplicates or multiple entries there for every employee what i want is that query to eliminate all just pick day first or say minimum time as time in and day last say maximum time as time out with date all these date fields are set to short time. example is ;