I have (with the help of this forum) created a query that takes date of birth and puts it in to an age range (the criteria for which is held in a table).
SELECT PD.[Patient SID], PD.[Date of birth], AR.Age_Range
FROM tbl_Patients AS PD, tbl_AgeRange AS AR
WHERE (((DateDiff("d",[PD].[Date of...