Entry

How can I search the database by more than one field and value at the same time?

Feb 14th, 2002 03:18
Luiz Paulo Rosa, Allie Lingo,

You can try
Conn.Execute "SELECT * FROM tblData WHERE Field1='00' OR Field1='01' OR 
Field2='00' OR Field2='01'"
Or 
Conn.Execute "SELECT * FROM tblData WHERE (Field1='00' AND Field2='00') 
OR (Field1='01' AND Field2='01')"
I hope this can be helpful