Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250

    Question 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.
    Last edited by poliarci; 04-03-04 at 16:42.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •