Not <> columns

  • Thread starter Thread starter Octet32
  • Start date Start date
O

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
 
Octet32 said:
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
Click to expand...
Put
<> [column2]
in the Criteria row in the grid column for [column1]
 
Thanks that worked

Bob Barrows said:
Octet32 said:
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
Click to expand...
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.
Click to expand...
 
Back
Top