MS Access 2003 query to select a record on multiple conditions
Posted on 2009-04-07
I need a query to select Field1, Field2, Field3, Field4 and Field5 from every record in Table1 *except* records that meet the following criteria:
- Records in table1 that have a "0" (zero) in Field3, Field4 and Field5.
- also have the first 4 numbers of a 6 digit number in Table1.Field2 match the first 4 numbers of Table2.Field1
Both points (conditions) must be met for the record to be excluded from query results.