I've a table called Attendance which has three fields - CardNo, Date, Time. This table has three record for each card no for one day, like -
003795, 20070216, 080203
003795, 20070216, 020315
003795, 20070216, 170203
How can I show records in a grid like - CardNo, Date, Time, WorkHous? What...