narrowing a search with multiple variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello and thanks for the help. I am using office XP. I have a table with two
fields tracking drug testing. Each patient is recorded as a patient ID
number. Any side effects they report are recorded with a code number. A
patient could have many side effects. Example: Patient #1 reports headache
which is coded as effect #7. Patient #2 reports headache which is coded as
effect #7. Patient #2 also reports sleepiness which is recorded as effect #5.
And the list continues for 50 patients.

Now I need to find patients that show up in the table with side effect #7
BUT only #7. In the example above this would only include patient #1. Patient
#2 could not be included because there is also effect #5.

Ideas???
 
SELECT tblTest.Patient
FROM tblTest
WHERE (((tblTest.Patient) Not In (SELECT PATIENT FROM tblTest WHERE
SideEffect <> 7)) AND ((tblTest.SideEffect)=7));
 
Back
Top