I have a table called UserEvents it contains InTimes and OutTimes of all users with perticular Date. The records comes through access control systems. I would like to make the attendance report which specifies the Intime, outtime and the total time for each users. I have attached the sample table with this(db1.mdb). can anybody help me?

Thank you.