G
Guest
Long-term, I hope to have this database redesigned, but that is not my
decision.
Anyway...
I have a list of people who attended classes. In the same table, the date
and time of the class is duplicated for each record. (This date and time
info does not exist elsewhere in the db.) I would like to extract each
unique combination of CName, Date, and Time.
I've only bee asked to do this once, and I took the query results into
Excel and used the Advanced Filter to get unique records only. What do I
need to do to accomplish this without going into Excel?
Thanks.
decision.
Anyway...
I have a list of people who attended classes. In the same table, the date
and time of the class is duplicated for each record. (This date and time
info does not exist elsewhere in the db.) I would like to extract each
unique combination of CName, Date, and Time.
I've only bee asked to do this once, and I took the query results into
Excel and used the Advanced Filter to get unique records only. What do I
need to do to accomplish this without going into Excel?
Thanks.