AND querys

C

Chris H

I have an access database that querys a SQL 6.5 database via ODBC. I have
created a query but need to use the AND operator, to select all records with
a certain audit codes, from the same table, such as all records with the
audit code LV-0080 and SU-0039, from the REPORT_FINDING table. I cannot seem
to sort out how to do this as the default is an OR query.

Any help please!!
 
O

Ofer

Try to set this sql

Select * From REPORT_FINDING Where [audit code] in ("LV-0080" , "SU-0039")
 
Top