Hi,

This one has me stumped!

I have a list of appointments for people (all of which have a unique ID). There are 2 services that they could have had an appointment with. Service A and B. I got as far as indicating if they have seen each service (e.g. Seen service A (yes, no), seen service B (yes, no). This is the bit I can’t work out. I have need to find the people who have seen service A and also service B. So check UID 001 - service A yes and yes for the same UID in service B.

At first I thought it would be very straightforward, if service A yes and service B yes...but each person could have several appointments so if I filter out the no’s from service A it rips out the yes’s in service B.

UID. Date. Service A. Service B
001. 1/1. Yes. No
001. 2/1. No. Yes
001. 3/1. No. Yes
002. 2/3. No. Yes
002. 3/3. No. Yes

From example above, only 001 has seen both services as 002 has only seen service B. Hope this explains it.

I Cheers