Search for everything "but" something

[scottsoo9]

This is a very simple question and I have tried to find the answer looking through older posts but cant. I am making a query and want it to show everything but something in a certain field. I know what I want it not to show. What is the command to make it do that? Thanks, Scott

 

[jdraw]

This is a very simple question and I have tried to find the answer looking through older posts but cant. I am making a query and want it to show everything but something in a certain field. I know what I want it not to show. What is the command to make it do that? Thanks, Scott

Select * FROM YourTable
WHERE fieldvalue <> "value to not show"

 

[scottsoo9]

I am not 100 percent understand what you are talking about. I am new at this so bear with me. I selected the field I wanted to query from my table. I was thinking that you would put a command in the criteria section. I do not get where to put the expression you gave me. ? Thanks, Scott

 

[Brianwarnock]

<> "value to not show"


in the criteria

 

[scottsoo9]

<"D">"value to not show"

I have typed that in and then run my query and get zero results.

I do not want to show the values of "D" and "C"

The ones I want to show, for the most part have nothing there. (they are not done or complete)

So do i want to show all the ones that are null?

There are also a few that have a status of something other than D or C that I want to show.

 

[boblarson]

<"D">"value to not show"

I have typed that in and then run my query and get zero results.

I do not want to show the values of "D" and "C"

The ones I want to show, for the most part have nothing there. (they are not done or complete)

So do i want to show all the ones that are null?

There are also a few that have a status of something other than D or C that I want to show.

<> "D" And <> "C"

is what you type. OR you can say

Not In("C", "D")

But please pay attention and actually READ what is being written. You say:

]<"D">"value to not show"

And Brian wrote:

<> "value to not show"

which doesn't mean to put the value inside the brackets. Try to remember Math from school - > means greater than, < means less than, <> means not equal to, = means equal to, and <= means less than or equal to, and >= means greater than or equal to.

And "value to not show" means to put YOUR value that you do not want to show as a substitute for those exact words.

 

[John Big Booty]

You seem to have misunderstood Brianwarnock, use;

<> "D"

<> is equivalent to Not Equal To

Given that you don't want to show the values "D" or "C", use;

<> "D" And <> "C"

in your criteria.

 

[John Big Booty]

Beaten to the punch whilst I was playing in my sandbox

 

[scottsoo9]

Gotcha, very new at this but you guys have helped me greatly