EXPRESSION FOR NOT EQUAL

Question

Is their a expression in Query Design that would only show unique records OR not equal?

Thanks Tom

Answer 1

That doesn't seem to work in my context.  I have a query in which there is a text field called "EndOfService" (which really should be a boolean but I didn't design this) that contains the letter "x" whenever that customer is dead or something.  In the query design screen, I can put an "x" in the criteria box and when run, only the records with "x" come up.  What I really want is all the records that DONT have an x.  If I look at the SQL, and replace the = with a <>, I get back no records.

WHERE (((tbl_Clients.[Fin de service]) ="x") AND ((tbl_Clients.NoMail)=False))

Answer 2

So what do you want to compare?    What not equal to what?

Answer 3

Here is my SQL Statement. In addition to doing what is named in this statement, I have a colunm named "SHORT BL" that have 7 numbers in it, that I only want the result to be if these numbers are different.

FROM [VEH1 RGT4]

WHERE ((([VEH1 RGT4].[VEH 1 RGT4]) In (SELECT [VEH 1 RGT4] FROM [VEH1 RGT4] As Tmp GROUP BY [VEH 1 RGT4],[SCAC],[SH DT] HAVING Count(*)>1  And [SCAC] = [VEH1 RGT4].[SCAC] And [SH DT] = [VEH1 RGT4].[SH DT])))

ORDER BY [VEH1 RGT4].[VEH 1 RGT4], [VEH1 RGT4].SCAC, [VEH1 RGT4].[SH DT];

Answer 4

What is the difference between a duck?

You'll need to clarify. "Not equal" to... what? Unique in what context?

Answer 5

Use     <>    which means it must be larger or smaller.