My attendance system records time IN and OUT in the format 5:00 AM and 5:00PM. I want to generate a report that "how many IN in between 7:00 AM and 8:00 AM"
if have tested as rs("eventtime")>"7:00" and rs("eventtime")<"8:00"
its working but its the same result for AM or PM.
How can i differentiate and test AM and PM.