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