The following should clearly outline the problem query output as well as the desired query output:
Attachment 855
The following should clearly outline the problem query output as well as the desired query output:
Attachment 855
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)