Date differences

G

GiBB

Hello,

Im a little stuck trying to do a datediff query.

i have two fields "request date" and "done date", and i need the query to
show all records which have a difference of 10 days or more. i.e. if it has
taken ten days or more from the date of request to the date of being done.

help!

Thanks in advance
 
A

Allen Browne

In the Criteria row under your [done date] field, enter:
Is Null OR > [request date] + 10
 
Top