M Mike D Aug 13, 2008 #1 I am trying to get a query to return the oldest member and youngest member in our database based on birthdate.
I am trying to get a query to return the oldest member and youngest member in our database based on birthdate.
J John Spencer Aug 13, 2008 #2 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
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
