Query for Oldest and Youngest Member

M

Mike D

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

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
 
Top