Date increment in query

[Chris]

I am having some trouble in setting up a criteria in my
query.
I have two fields: [date of reply] and [close out date].
This is what I would like to achieve:

When [date of reply] is greater or equal to 14 days from
today's date, and if [close out date] is null, I will have
a return.
Can this be done?

Many Thanks,
Chris.

 

[John Vinson]

I am having some trouble in setting up a criteria in my
query.
I have two fields: [date of reply] and [close out date].
This is what I would like to achieve:

When [date of reply] is greater or equal to 14 days from
today's date, and if [close out date] is null, I will have
a return.
Can this be done?

Sure: create a Query based on the table and put a criterion on [Date
Of Reply] of

= DateAdd("d", 14, Date())

and a criterion on [Close out date] of

IS NULL

 

[Guest]

Thanks a lot for your help.
Chris

-----Original Message-----

I am having some trouble in setting up a criteria in my
query.
I have two fields: [date of reply] and [close out date].
This is what I would like to achieve:

When [date of reply] is greater or equal to 14 days from
today's date, and if [close out date] is null, I will have
a return.
Can this be done?

Sure: create a Query based on the table and put a criterion on [Date
Of Reply] of

= DateAdd("d", 14, Date())

and a criterion on [Close out date] of

IS NULL


.