Dates in queries

  • Thread starter Thread starter Chris
  • Start date Start date
C

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.
 
Hi,


What is a "return" ?

SELECT *
FROM somewhere
WHERE existingCriteria AND NOT (

[date of reply] + 14 > Date( ) and [close out date] IS
NULL

)



would return an empty recordset under the described circumstances.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top