Actually, this was much simplier than I originally anticipated....
All you want to display is anyone with a birthday during the month in question and between today+7 and today+21...There is no need to even worry about the year of birth......
So assuming a table called Table1 with two fields, Name and BithDate, the following SQL will extract anyone with a birthday between the above dates....
SELECT Table1.Name, Table1.BirthDate
FROM Table1
WHERE (((Month([Table1]![BirthDate])) Between Month(Date()+7) And Month(Date()+21)) AND ((Day([Table1]![BirthDate])) Between Day(Date()+7) And Day(Date()+21))); Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!
Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com