recordset advance query

I'd like to have a query for the first and last name on an enrollment list so that only one result show. Howeve开发者_如何学运维r, if only the last name is chosen in the query multiple answers will show.

---

You can GROUP BY the last name field in your query.

For example if you had this data:

MyTable:
id last_name first_name
1  Smith     John
2  Smith     Jane
3  Jones     Paul

Running a query like this:

SELECT t.last_name 
  FROM MyTable t
GROUP BY t.last_name
ORDER BY t.last_name

...would return these two rows:

Jones
Smith