Hi,
New to this forum and access so apologies if this is a very basic question.
I have 3 tables lets call them Identifier, Left and Right (referring to Left and Right arms)
Identifier contains the ID's and age, DOB, etc of all the patients in my database
Left and Right contain the ID and specific measurements of each arm. There can be numerous entries within Left or Right for each ID because each patient can have measurements taken at different times.
I need it so that when I run a query for a specific measurement within the Table Right, ie Circumference of wrist < 10 cm, not only does it return the record of all the patient's that meet that criteria, but also all other records in Right and Left of that patient who has met the criteria, even if their other visits do not necessarily meet the criteria.
Table: Right Arm
Patient ID Visit ID Wrist Circumference 1 1 9 2 2 11 3 3 11 1 4 11 2 5 11 3 6 11
So for the table above I would want it to return Visit ID 1 and 4 since they both below to Patient ID 1, whose visit 1 meets the criteria.
Really sorry if I explained this way more complexly than necessary for a simple problem, thanks for all the help.