only show ones have have null value on a field

[Fugan]

only show one have have nothing value

hello,
i have a querie, haves jobs information in it and one field called "Date Finished Fixing"

i want the querie to only show the ones with out dates put in so if they =nothing i don't no how to do it can someone help

 

[Rich]

Is Null in the criteria section for your date field

 

[Fugan]

rich,
hello i put isnull in criteria and did not work
it does isnull and then i tried isnull([fieldname]) and still does not work do u no what i'm doing wrong can u show me eg

 

[Bodisathva]

richi put isnull in criteria and did not work

Is Null in the criteria section for your date field

In the query builder, the criteria is "Is Null" in the SQL statement you use the function IsNull()