>Here is the sql syntax for the query that is failing:
>
>SELECT icitem01.item, icitem01.cntcode, [BOM Top Level Cycle Count
>Codes].CycleCntCode
>FROM icitem01 INNER JOIN [BOM Top Level Cycle Count Codes] ON icitem01.item
>= [BOM Top Level Cycle Count Codes].PARTNO
>WHERE (((icitem01.cntcode)<>[CycleCntCode]));
>
>The problem is that when it runs, it return 2 or 3 different rows everytime
>it runs and it should not return any rows at all. The reason it shouldn't
>return anything is because the two values that are used in the where clause
>are both equal to each other in every row of the table that I'm using.
>Please help me in any way you can.

What type and size are the fields? It may be having problems with leading/trailing spaces depending on the data type of the fields. Also you don't need any parenthesis after the WHERE clause.