Results 1 to 7 of 7

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

Hybrid View

  1. 11-26-2020, 07:16 PM #1
    June7
    June7 is offline Registered User
    Join Date
    Nov 2020
    Posts
    35
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules