-
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.
-
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
-
Forum Rules
|
|