Query command for "not equal to".

[clixgamer]

Well for some reason the query wizard is not working. So in design view I need to know the command for "not equal to".

I am trying to sort out all of the completed jobs in my table so that results from the query lists everything but the completed jobs. I have tried '<>Completed' , but the query results come back as nothing.

I have managed to do the opposite and query all of the completed jobs. That is not what I want.

Pleas help.

[FJCC]

The syntax is

Code: Select all

 <> 'Completed'

[clixgamer]

Ok I see what I was doing wrong there. But after applying what you suggested, query comes back with all the record in the table. It doesn't seem to be omitting the "Completed" projects.

[F3K Total]

Hi,
just an idea:
If "Completed" is a boolean column then try

Code: Select all

... where "Completed" = false

R