I have a database called attendance and i want to delete any duplication based on today date for same employee?

I have a table called attendance report which will import from attendance table once i click on a button name WORK IN.

 

Thanks for your advise.

 

Regards,

 

Kishan

I want to delete a duplicate records  created on the same day based on time creation priority?

 

Example:

 

Date 13/04/2013

2:15 Kishan

 

Date: 14/04/2013

2:30  Kishan

14:20  kishan  <----- To delete duplicate

I have merged your posts. Please do not double post.

"table called attendance report which will import from attendance tab"

 

Why do you have two tables to track attendance? Can you post your data model?