Hello guys,
I noticed that "<>" has not been working for several of my queries in the query design view and the SQL View. Is there a reason why?
I have 2 queries and I want records where the 2 states are not equal but it is returning all the states from one of the query
Here is the SQL View code
In the Design View, I have: <>[QryBobRegistration].[StateRegistered] on the Criteria Row.
What am I missing?
I noticed that "<>" has not been working for several of my queries in the query design view and the SQL View. Is there a reason why?
I have 2 queries and I want records where the 2 states are not equal but it is returning all the states from one of the query
Here is the SQL View code
Code:
SELECT Qry_States.State
FROM QryBobRegistration, Qry_States
WHERE(((Qry_States.State)<>[QryBobRegistration].[StateRegistered]));
In the Design View, I have: <>[QryBobRegistration].[StateRegistered] on the Criteria Row.
What am I missing?