Access 2007 query not working

[mcgraw]

Ok, I have worked this query up one side and down the other. It's simple, so it shouldn't be giving me so many problems!

All I want is a query that doesn't show anything with a status of "Closed", "Cancelled" or "Unfunded"

Here's my query...

SELECT Issues.*
FROM Issues
WHERE (((Issues.Status)<>"Closed")) OR (((Issues.Status)<>"Cancelled")) OR (((Issues.Status)<>"Unfunded"))
ORDER BY Issues.Status, Issues.Priority, Issues.Due_Date;

Every time I run this in Access 2007, it doesn't return closed, but it does return cancelled and unfunded?

So, what something small and stupid did I do wrong?

Any help would be appreciated!

 

[boblarson]

Change the OR's to AND's

WHERE (((Issues.Status)<>"Closed")) AND (((Issues.Status)<>"Cancelled")) AND (((Issues.Status)<>"Unfunded"))

 

[mcgraw]

oh for the love of all that is holy. Ok, I can't even blame that on having too much to drink, or being overtired...just plain old being stupid!

Thanks!

 

[boblarson]

No problem (believe me, I've been there and done that myself )