Search results

  1. B

    Combining 2 queries

    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...
  2. B

    Solved Update Query Based on Columns in Another Table

    I have 2 tables. Table one [Person_Details] Person ID Date of Birth Age in Days Age Range KL123 26/07/1994 10254 26-40 DJ348 24/01/2000 8346 18-25 Table two [Age_Range] Min Age Days Max Age Days Age Range 0 6570 <18 6570 9490 18-25 9490 14965 26-40 I want to update Age...
Top Bottom