Criteria: >9 and a non null value in another field

[Mousewrites]

Not sure how to get my query to return the numbers I want.

What I want it to do is look to see how many days it has been since the bug has been corrected, and then return values that are 10 days or over. But I also need it to disregard bugs that have been verified (any date in the 'verified' field).


Currently I have a query that has the Bug ID as one field, and the other contains this expression "Expr1: DateDiff("d",[tblBugs]![dtmDateCorrected],Now())" with the criteria >9.

Where and how do I get it to check if their is a non null value in the verified feild?

 

[mdmilner]

Might be as simple as the criteria

Not IsNull

From your description, dropping this line in the criteria (QBE Design mode) under the field for dtmDateCorrected will handle it.

If you look at your query in SQL View, you'll see two conditions listed after the WHERE parameter connected by an AND.

Mike