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

Is Null in the criteria section for your date field

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

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()