The SELECT statament could include a condition (after WHERE clause) to filter the records returned to the recordset.

Example:

SELECT * FROM table WHERE field1='XYZ'

In this case the 'XYZ' is the filter for the field1.

How can I write the statament to fileter for two fields. (field1 and field2)??

Any idea will be appreciated.

Thanks!

Ulises