"Not equal" problem

[dubiic]

Hello!

Let's imagine that I have 2 columns in my table "user company" and "owner"

This time I am trying to make query which shows only these rows where "user company" and "owner" doesn't match.

I came up with something like this obviously:

[tbl_hardware]![User company]<>"Equal to [tbl_hardware]![Owner]"

In theory I cant see problem why this thing wouldn't work, but in reality atm my query is giving back everything like with 20 or more duplicates

Thanks in advance,
Jānis.

 

[twoplustwo]

Poast a sample of the data (zip and attach!)

 

[twoplustwo]

Should do it.

 

[dubiic]

I tried

Not Like "[tbl_hardware]![Owner]"

Not Like [tbl_hardware]![Owner]

Not Like "Owner"

None of these worked, I have same layout as in your sample.

 

[twoplustwo]

Attach your db and I'll take a look.

My query worked fwiw.

 

[dubiic]

Not Like [tbl_hardware]![Owner]

seemed to be right answer, I opened my query in sql view and there was clearly something wrong with tables ( that _1 thing ) I fixed it and everything works great now.

SELECT tbl_hardware.Hardware, tbl_hardware.[Inv number], tbl_hardware.[Serial Number], tbl_hardware.[User company], tbl_hardware.Owner
FROM tbl_hardware
WHERE (((tbl_hardware.[User company]) Not Like tbl_hardware.Owner)) Or ((tbl_hardware![User company] Is Null));

Thanks!