title: Exclude records from query where some columns are all not equal to a value
body: <p>I am relatively new to ACCESS 2010 and to SQL. Having a bit of trouble figuring this one out.</p>
  
  <p>I have a a query that returns a result from a table. I want to exclude any records where the values in columns A1-A4 all equal zero.</p>
  
  <p>ex:</p>
  
  <pre>
  +----+----------+----+----+----+----+
  | ID | CustName | A1 | A2 | A3 | A4 |
  +----+----------+----+----+----+----+
  |  1 | Ben      |  0 |  0 |  0 |  0 |
  |  2 | Tom      |  0 |  0 |  0 |  1 |
  |  3 | Jerry    |  0 |  0 |  2 |  0 |
  |  4 | Steve    |  0 |  3 |  0 |  0 |
  |  5 | Dave     |  4 |  0 |  0 |  0 |
  |  6 | Mike     |  0 |  0 |  2 |  1 |
  |  7 | Sheila   |  0 |  3 |  2 |  1 |
  |  8 | Jonesy   |  4 |  3 |  2 |  1 |
  +----+----------+----+----+----+----+
  </pre>
  
  <p>Using the table above as the source for the query, the only record I want to be excluded should be the very first record. </p>
  
  <p>The SQL I am using for this query is </p>
  
  <pre><code>SELECT Test.CustName, Test.A1, Test.A2, Test.A3, Test.A4
  FROM Test
  WHERE (((Test.A1)&lt;&gt;0) AND ((Test.A2)&lt;&gt;0) AND ((Test.A3)&lt;&gt;0) AND ((Test.A4)&lt;&gt;0));
  </code></pre>
  
  <p>This SQL will only return records where all columns from A1-A4 are NOT equal to zero and only returns the final record. It should return record 2 - 7. </p>