Results 1 to 2 of 2

Thread: Access 365 - Query - Duplicate Unique Values in query output - how to resolve please

  1. #1
    Join Date
    Sep 2019
    Posts
    1

    Access 365 - Query - Duplicate Unique Values in query output - how to resolve please

    The following should clearly outline the problem query output as well as the desired query output:
    Access 365 Query Issue.JPG

  2. #2
    Join Date
    Nov 2020
    Posts
    5
    Need a unique identifier field in table, autonumber should serve.

    FTEValue: IIf(DCount("*", "Table", "PositionNumber=" & PositionNumber & " AND ID<" & ID)=0,1,0)

    or

    FTEValue: IIf((SELECT Count(*) FROM Table AS Dupe WHERE Dupe.PositionNumber=Table.PositionNumber AND Dupe.ID<Table.ID)=0, 1, 0)
    Last edited by June7; 11-27-2020 at 02:39 PM.

Tags for this Thread

Posting Permissions

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