How do i use more than one criteria ( about 6) in a query?
D Duane Hookom Dec 19, 2004 #2 The same way that you would use one criteria. The only complexity might be if you want to use ANDs or ORs in your criteria.
The same way that you would use one criteria. The only complexity might be if you want to use ANDs or ORs in your criteria.
K Ken Snell [MVP] Dec 19, 2004 #3 By listing each separately in the WHERE clause: WHERE [Field1] = "Value1" And [Field2] = "Value2" And .... etc. Or, use Or for logic of accepting any of the choices. Or, use various combinations with parentheses to get more complex logic results.
By listing each separately in the WHERE clause: WHERE [Field1] = "Value1" And [Field2] = "Value2" And .... etc. Or, use Or for logic of accepting any of the choices. Or, use various combinations with parentheses to get more complex logic results.
