query for a not null value

[sbbrown9924]

How would you write a query to capture all records that have a field value that is not null? The field is a number. Thanks.


SELECT * From Table where ---> Field Is Not Null <---

 

[belovedcej]

WHERE Not((Name of Field) Is Null))

Shouldn't make a difference if it is a date field or text field, if the value truly is null.

 

[belovedcej]

oops - parentheses in wrong places:

(Not((fieldname) Is Null))

 

[lespaul]

Does Access allow a null value in a number field? DB2 puts a 0.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[r937]

what is up with all the nested parens, people

access sql works fine without them

WHERE Field IS NOT NULL


leslie, yes it does

r937.com | rudy.ca

 

[lespaul]

wow, learn something new everyday!

thanks rudy!

les