extract one of each record

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Hi, TJ.
used the Advanced Filter to get unique records only. What do I
need to do to accomplish this without going into Excel?
Click to expand...

Use the DISTINCT keyword in your query. For example, create a new query and
open the SQL View pane to paste the following:

SELECT DISTINCT CName, Date, Time
FROM MyTable;

.. . . where MyTable is the name of the table. Since Date and Time are
Reserved words and should be changed to avoid hard-to-track bugs, while
you're fixing the database you'll want to address this issue, too.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
 
Thanks! I'm about to play with it myself, but if you look back at this
thread, here's an additional question:
Can I return additional columns while only applying DISTINCT to the same
three fields?

Thanks.
 
Back
Top