<> does not work, but = does - Access 2002

[cervantes008]

I built a temp table(KEEPER) to from the original (V1A) to null the duplicate numbers with a lesser value.
(IIf([v1a]![OEM DCs]<>[KEEPER]![MaxOfOEM DCs],9999999,[KEEPER]![Seq])

When I use this, nothing gets updated. I've also used [v1a]![OEM DCs]<[KEEPER]![MaxOfOEM DCs] Now when I use = it works fine.

Has anybody ever had this problem?

 

[Brianwarnock]

Never tried it, but if = works then you can always switch the true/false round.

Brian