Within a date range query

[simon4amiee]

Hi again guys I have 2 table both with Date of Births, the field name in one is DOB and the other its DateOfBirth.

How would a write an IIf Statement that would say If DOB is within 10 days either side of DateOfBirth then "Yes" else "No".

 

[namliam]

abs(dob-dateofbirth)<=10