Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unique Records (2000 SR-1)

    I have the UniqueRecords property in a select query set to "Yes", but still returns duplicate records. Any clues?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Unique Records (2000 SR-1)

    What is duplicated?

    Post the queries SQL here so we can have a look.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unique Records (2000 SR-1)

    How do I post the SQL?

  4. #4
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unique Records (2000 SR-1)

    SELECT DISTINCT IIf([ParentTable]![AltLastName] Is Not Null,[ParentTable]![AltLastName],[ParentTable]![LastName]) AS ParentLastName, IIf([ParentTable]![FatherFN] Is Null Or [AltLastName] Not Like [LastName],[ParentTable]![MotherFN],[ParentTable]![FatherFN] & " & " & [MotherFN]) AS ParentFirstNames, Ushers.Ushers, ParentTable.Address, ParentTable.City, ParentTable.State, ParentTable.Zip, StudentTable.StudentHomePhone, ParentTable.EMail1
    FROM (ParentTable INNER JOIN StudentTable ON ParentTable.ParentID = StudentTable.ParentID) INNER JOIN Ushers ON ParentTable.ParentID = Ushers.ParentID
    ORDER BY IIf([ParentTable]![AltLastName] Is Not Null,[ParentTable]![AltLastName],[ParentTable]![LastName]);

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Unique Records (2000 SR-1)

    Give an example of what is duplicated, remember all the fields that are selected are used in the distinct.

Posting Permissions

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