Return only one instance of a single field

[runtheeast]

I am writing a query with a few fields- first name, last name, e-mail, address, city, state, zip, registration date.

I am trying to write a query (or possibly multiple queries if necessary) that do the following:

1. Only return the latest instance (according to registration date) of a single e-mail address. I have this much down (by itself).
2. Only return a single instance of an address. So, if my wife and I are both in the database, I only want one of our records to be returned.

Like I said, I have #1 down by itself. Any ideas of how to do both of these together? I've tried doing a subquery/nested select but no dice so far.

Thanks for any help.

[June7]

For 2 you could maybe do a query using the TOP parameter. Review http://allenbrowne.com/subquery-01.html#TopN