Query for Oldest and Youngest Member

[Mike D]

I am trying to get a query to return the oldest member and youngest member in
our database based on birthdate.

 

[John Spencer]

The SQL statement for the query would look like:

SELECT Members.*
FROM Members
WHERE Members.DOB = (SELECT Max(DOB) FROM Members)
OR Members.DOB = (SELECT Min(DOB) FROM Members)


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County