I have two columns for example, I want to list all the rows where the items in ROW A appears more than once in Column A, but have distinct values in Column B. So far I have not figured out an answer. i tried the one below but in MS Access you can't use distinct and count at the same statement i get undefined distinct function error.
FROM xyz table
GROUP BY ColumnA
HAVING COUNT(DISTINCT ColumnB) >= 2;
Column A Column B