Hi
Sorry not sure on the title
I am new. The last time I used access was when I was in secondary school 9 years ago. Please would you be able to help me with a query
I have made a table for when my staff are late, it includes:
Employee Name
Date
Start time
Time of text
Arrival time
Notes
Lateness - this is a calculated field, arrival time-start time
I do want to make a query of showing how many times particular employees are more then 5 minutes late. I have tried ">#00:05:00#". I have no clue what to put
Sorry not sure on the title
I am new. The last time I used access was when I was in secondary school 9 years ago. Please would you be able to help me with a query
I have made a table for when my staff are late, it includes:
Employee Name
Date
Start time
Time of text
Arrival time
Notes
Lateness - this is a calculated field, arrival time-start time
I do want to make a query of showing how many times particular employees are more then 5 minutes late. I have tried ">#00:05:00#". I have no clue what to put