As a SQL query:
select c1.accountno, c1.contact, c2.udob
from contact1 c1
join contact2 c2 on c1.accountno = c2.accountno
where datename(dy,c2.udob) >= datename(dy,getdate()) and datename(dy,c2.udob) <= datename(dy,getdate())+7
Determines the dates using day number (ie Jan 1st = 1, Feb 10th = 41 etc)
Assumes your date of birth field is contact2.udob; change as appropriate!
Thanks Ronan, will give that a try and your assumption is spot on, it is udob!
Hi Ronan, just tried your statement and it works. Thanks for your help.