I'm looking to run a query that can show me reoccurring account numbers. I have a status column which can have a status such as New, Completed or In Process. I have another column with account numbers in it. In my database there are times where an account will have a status as completed and a status as New when their issue reappears. I'm looking to run a query that can show me all account numbers that have a status of New and Completed. I will attach a screen shot of my table in excel. Appreciate any help anyone can offer.