Hi friends,

   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.

Thanx.

Hi

You could maybe look at using something like
Y = Format(varValue, "HH:mm") where varValue will be your recordset or value containing the time. This will convert 10:00 PM to 22:00 and so on.

Hope this helps.

Regards
Marnus