Date Criteria for Open and Closed records

  • Thread starter Thread starter MAX
  • Start date Start date
M

MAX

Hello,

I have a date field [Closed]. In the query I want to show
those records that where [Closed] is either null (open),
or have been closed for less than a week. Anyone know how
to write the criteria for this?

Many thanks,

Max
 
Try this in the criteria box in the design grid.

Is Null Or >=Date()-7
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Date Expressions/Criteria 1
Checkbox controlled criteria 2
Identify closed/finalized records the month they were opened Acces 2
counting Null fields 3
Criteria for Max date 2
Filtering Criteria Question 2
Criteria issue for limiting a query 2

Back
Top