I am working on a database with a table for patients and a related table for patient visits at clinic, where the relationship is 1-m. On the patient visit table, I have three variables to record whether certain iamge was taken at the visit as Yes/No. I call the three variables as Img1, Img2, and Img3. A patient might get all the three images done at one visit or multiple visits.
My question is how to find those patients who havenot taken all the three images across multiple visits from the database? I tried a portal of the visits on the patient layout but I can not do a direct search to find those who havenot taken all the three images across their visits. It seems that I need some aggregate function to summarize the data but I did not find an appropriate function to use.
Your input and suggestions on answering the question is highly appreciated.
Thanks a lot,