Not <> columns

[Octet32]

I am trying to find out which columns are not equal in a query in Criteria I
have placed the following
<>([column1 ]![ column2])
It doesn’t work anyone know how to do this?
octet

 

[Bob Barrows [MVP]]

I am trying to find out which columns are not equal in a query in
Criteria I have placed the following
<>([column1 ]![ column2])
It doesn't work anyone know how to do this?
octet

Put
<> [column2]
in the Criteria row in the grid column for [column1]

 

[Octet32]

Thanks that worked

I am trying to find out which columns are not equal in a query in
Criteria I have placed the following
<>([column1 ]![ column2])
It doesn't work anyone know how to do this?
octet

Put
<> [column2]
in the Criteria row in the grid column for [column1]
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.