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