Unanswered: Reducing Distinct row to distinct column?
I have a query which looks for duplicate records on a given column that differ on on other columns. I look for duplicate file names which have different size, time, or date. Now, I can get it by using a query that uses the wizard for duplicates then creating a second query which groups by filename using this first query as the source. Is there an easier sub-query? Or would a create table for the first query make the naming of fields a bit easier?
PS-- I solved this another way. I created temporary tables as I needed.