title: Populating columns with a value based on a condition
body: <p>I have a table containing fields called 'Category' and 'TotalTime'. When I run a query, I need to generate two additional temporary columns called 'Cat1Time'and 'Cat2Time'.</p>
  
  <p>If the total time in a row is 4 hours and it is category 1, it should display a '4' under the Cat1Time column. If the total time in a row is 4 hours and it is category 1, it should display a '4' under the 'Cat2Time' column. Is there a way to do this? </p>
  
  <pre><code>EntryID | Category | Cat1Time | Cat2Time
  2       |  1       |   4      |    
  3       |  2       |          |   4
  4       |  1       |   2.5    |   
  
  
  
  
  Select EntryID, Category, TotalTime AS Cat1Time 
  WHERE Category =1, TotalTime as Cat2Time where Category = 2 
  from LogEntry
  </code></pre>
  
  <p>Anyways, I know that won't work... it's just to give you an idea what I am trying to do. Any help would be greatly appreciated!</p>