Multiple Criteria In SQL Statement

Hi

I was just wondering if it is possible to specify multiple criterias in one SQL statement such as selecting results where a particular field equals no AND another filed has to be between two dates. I know you cant use multiple where clauses, so I have no idea how its done.

Help appreicated

Is this what you are looking for?

Code:

---

Select * from table where a=y and datevalue between date1 and date2

---

You can have as many criteria as you want to include using AND and OR in the WHERE clause