Not In ("Completed"," Canceled")

I want to exclude the status of Completed and Canceled from my query. I
tried using different combinations of the above line, but it does not exclude
them.

Any suggestions would be most appreciated.
--
Bonni

Post the entire SQL Statement you are trying to use.
(Hint: View: SQL from menu, copy and paste)

What you posted should work assuming that the field contains those values - if
the field is a look up field then what you see may very well be different than
what is actually stored in the field.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Bonni Wilbourne wrote:
> Not In ("Completed"," Canceled")
>
> I want to exclude the status of Completed and Canceled from my query. I
> tried using different combinations of the above line, but it does not exclude
> them.
>
> Any suggestions would be most appreciated.

From what I understand:

SELECT *
FROM somewhere
WHERE process NOT IN( SELECT process
FROM somewhere
WHERE status IN("completed",
"canceled") )


to remove all process having one of their status equals to completed or to
canceled. I assume data like:

process dateTime status 'fields

1010 2001.01.01 open
.....
1010 2002.02.02 finding financing
....
1010 2002.03.03 canceled




Vanderghast, Access MVP



"Bonni Wilbourne" <(E-Mail Removed)> wrote in
message news:BB34844C-E60A-419B-8C27-(E-Mail Removed)...
> Not In ("Completed"," Canceled")
>
> I want to exclude the status of Completed and Canceled from my query. I
> tried using different combinations of the above line, but it does not
> exclude
> them.
>
> Any suggestions would be most appreciated.
> --
> Bonni

There's a space between the " and word Canceled. Could that be the problem?

If not, post the entire SQL statement.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Bonni Wilbourne" wrote:

> Not In ("Completed"," Canceled")
>
> I want to exclude the status of Completed and Canceled from my query. I
> tried using different combinations of the above line, but it does not exclude
> them.
>
> Any suggestions would be most appreciated.
> --
> Bonni