title: cross query Question - (sum & avg)
body: <p>is it possible with cross query to do this ?  (in Access 2007)</p>
  
  <p>I have this table:</p>
  
  <p>50 | A1</p>
  
  <p>60 | A1</p>
  
  <p>70 | B1</p>
  
  <p>80 | B1</p>
  
  <p>90 | C1</p>
  
  <p>I need to get this result:</p>
  
  <p>A1         ------------------               B1        ---------------             C1</p>
  
  <p>sum | avg    -----    sum | avg   -----   sum | avg </p>
  
  <p>55   | 110   ---------     75 | 130   ------         90 | 90</p>
  
  <p>I try to wright this:</p>
  
  <pre><code>TRANSFORM Sum(Worki.Value) AS XXsum
  SELECT Worki.Name AS Name, Worki.Tdate AS Tdate, Worki.ID AS ID
  FROM Worki
  GROUP BY Worki.Name, Worki.Tdate, Worki.ID
  PIVOT Worki.Trit;
  </code></pre>
  
  <p>How I can Get the average and the Sum ?</p>