I think I need to use the Last() or First() method, but I'm not sure how
that would work. I want to end up with a query that has just one record per
person.
Last() is pretty nearly completely useless, and First() isn't much
better: they return the last and first records IN DISK STORAGE ORDER,
which is pretty much arbitrary.
I think instead you should view the query's Properties (right
mouseclick in the grey area behind the tables and select Properties),
and set the Unique Values property of the query to Yes. This will give
you one record for each combination of the selected fields. Don't
include the Primary Key field or any other field that will have
multiple values per person.
John W. Vinson[MVP]