return max/min value in single query

[garamon]

I have a table listing employee names and their birthdates. I have to create a single query that returns the names of the oldest employee and youngest employee. it's easy to return only their birthdays, but i can't figure out how to return the names (with or without their birthday). I can only use a single wuery.

[alansidman]

Assume all are info is in Table1, Names are in Name1 and Birthdays are in Date1, then your query would look like this:

SELECT Table1.ID, Table1.Name1, Table1.Date1
FROM Table1
WHERE (((Table1.Date1)=(Select Max (Date1) from Table1))) OR (((Table1.Date1)=(Select Min (Date1) from Table1)));

This query will return the oldest and youngest.

[garamon]

thank you so much!!