AND querys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
Try to set this sql

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