I could use some assistance with calculating a client’s age (at arrest) based on their date of birth and the date they are arrested, these dates being in two different tables. Within the Client Table (ClientTbl) there is static information such as: ID Number, Last Name, First Name, Sex, Date of Birth, etc… Within the Court Table (CourtTbl) there are fields like: ID Number, Court Date, Arrest Date, Charge, Age, etc…. Within “Age” field in the Court Table, I would like to calculate the clients age at time of arrest based on these two dates. I have included an example below:
ClientTbl: Sample Data ID Number Last Name First Name Sex
DateOfBirth
Ter124
Doe
John
Male 12/05/1974
CourtTbl: Sample Data ID Number CourtDate ArrestDate Charge
Age
Ter124
04/13/2018 04/12/2018 DUI
???
Obviously, this client would be 43 years old, but that is the formula that I am having trouble with because the dates are in to different tables and I need to match ID Numbers. Thank you in advance for your assistance.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |