Results 1 to 2 of 2

Thread: Multiple criteria in a query

  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Multiple criteria in a query

    I am trying to write 2 different criteria filters, but can't get it to work.
    I have a date field and a status field. I want the result to show all records within a date range (both "closed" and "working") AND any record that is "working".
    I know this should be simple, but it's driving me crazy! Please help.

  2. #2
    Join Date
    Nov 2009
    Posts
    6
    Does this work ?

    SELECT *
    FROM status
    WHERE (status.row_date>DateValue("31/12/1999") and status.row_date<DateValue("01/01/2001") and status.status in ("closed","working"))
    OR
    status.status = "working"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •