Help with duplicate records

Results 1 to 4 of 4

Thread: Help with duplicate records

  1. #1
    Chris A. Guest

    Default Help with duplicate records

    I have a question about a recordset I&#039m working with. I have records that all have unique date and time stamps (in separate fields) that will from time to time contain duplicate data in other fields. <BR><BR>I&#039d like to just display the most recent of the "duplicate" records, and ignore the rest (but preserve them in the database--I don&#039t want to delete them). <BR><BR>Is there a way to write such a SQL statement? <BR><BR>Please help...! <BR><BR>= ) <BR><BR>C. A. <BR>

  2. #2
    Already in Databases Q&A Guest

    Default CROSSPOST


  3. #3
    Chris A. Guest

    Default I know, I'm sorry...but I still need help. =

    = )

  4. #4
    Join Date
    Dec 1969

    Default RE: Help with duplicate records

    I will try and help but just watch the cross-posting...<BR><BR>SQL = "SELECT TOP2 fieldname FROM tblXXX WHERE duplicatvalue = duplicatevalue ORDER BY desc"<BR><BR>This should work, I think....

Posting Permissions

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