title: [MS ACCESS]Generate a result column based on the content of other columns?
body: <p>I want to be able to generate some feedback columns based on the content of other columns, for example. how can I accomplish this in access? Columns Crew, Date, and Trade are predetermined from the source table, Pass/Fail and Cause would be generated with the new addition.</p>
  
  <pre><code>**Crew**  l   **Date**     l   **Trade** l **Pass/Fail** l **Cause**
  ___________________________________________________________________
    123A    l 3/22           l WORK        l Fail          l Crew, Date, Trade
    123B    l ___            l WORK        l Fail          l Crew, Trade
    ____    l ___            l ____        l Pass          l   
  </code></pre>