how to make a query doesn't show the records (null) ?

[mostafa moniem]

i need a query that doesn't show records that has a certain fields (null)

[jforbes]

You can use the Is Null criteria to perform the desired function. It's pretty straight forward. This is from Mirosoft: Examples of query criteria

Is Null
This criterion can be applied to any type of field to show records where the field value is null.

[mostafa moniem]

i want it don't show the record if it is null

[jforbes]

It's pretty much the same thing with the Not keyword inserted into it. That is also detailed in the link: Examples of query criteria

Is Not Null
Returns records where the value is not missing in the field.