title: Combining 2 similar fields into 1 in MS Access
body: <p>I have 5 columns: c1=Item, c2=LHrs, c3=WHrs, c4=Lead, c5=Worker, constructed as such:</p>
  
  
  
  <pre class="lang-none prettyprint-override"><code>ITEM  LHRS  WHRS  LEAD  WORKER
  123   25    10    John  Gary
  456   15    20    John  John 
  </code></pre>
  
  <p>I want results to appear like such:</p>
  
  <pre class="lang-none prettyprint-override"><code>RESOURCE  ITEM  HRS
  John       123   25
  Gary       123   10
  John       456   35 
  </code></pre>
  
  <p>Concatenate on the names and doing the results "AS Resource" doesn't break it down the way I want. Basically I want to know for each person, for each item, how many hours they are working wheter they are Lead (LHrs) or Worker (WHrs).</p>
  
  <p>Thoughts?</p>