title: How to add a calculated column using conditions in a query in MS Access 2010
body: <p>I have two tables and from that I am generating a query. I have columns in my query with field type yes/no. These are basically columns to determine the race of a person. The user enters information in yes/no for various races. I want another calculated column in the query which checks for all other race columns and calculates values in it. </p>
  
  <p>I have to check for a few conditions in for the values in columns 
  For example:</p>
  
  <p>1) If Hispanic is chosen, the new column should say hispanic(no matter what other options are selected. This is like a trump card)</p>
  
  <p>2) If more than one is selected, then new column entry should say "multi"</p>
  
  <p>3) If none of the options are selected, it should say "unknown"</p>
  
  <p>4) If exactly one of them is selected, then that race should be displayed</p>
  
  <p>Can anyone help me with this? I am new to Access</p>