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
 
Back
Top