Query design

[nejenkins]

I have a database of patient who received different operations. I would like to have a list of patients who have received operation ‘x’ with also, just for those patients’ a list of all the other operations they have had.

[June7]

SELECT * FROM table WHERE PatientID IN (SELECT PatientID FROM table WHERE Operation = "x");

[nejenkins]

do i type this in the criteria box of the field in the design view of the query?

[June7]

Do you mean the IN operator and nested SQL, yes it goes in criteria.

Can try typing in SQL view and then switch to Design view.