Results 1 to 4 of 4

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
    13
    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.

  3. #3
    Join Date
    May 2021
    Posts
    1
    Is Access 365 still available? I thought MS announced its end of life in 2018

  4. #4
    Join Date
    Feb 2014
    Location
    Riviera Beach, Maryland, USA
    Posts
    79

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
  •