I have a table in MS Access like following
ID name city
2 A P
3 B Q
4 C R
5 A Q
6 B P
7 C P
Now I need the query for records (Name in group by ) where city = P and also city = Q
so the output of records where above both conditions must fulfil.
so the result should be
I tried ConcatRelated function, but in my actual table the fields are large so it does work.
above table is just to understand clearly.