title: Cross-Tab Query or other option?
body: <p>I'm not sure if a cross-tab query is the ideal way to do this, I haven't been able to make it work.</p>
  
  <p>I have a table of contact information from all customers, formatted as follows (with sample data):</p>
  
  <pre><code>Customer # | Contact Name | Telephone Number | E-mail Address
  -----------+--------------+------------------+---------------
  32         | John         | 123-123-1234     | test@test.com
  32         | Deb          | 123-211-6547     | deb@test.com            
  71         |              |                  |
  76         |              |                  |
  123        |              |                  |
  </code></pre>
  
  <p>How can I create a query that will take all contacts for each facility and put them on one line? So it would have:</p>
  
  <pre><code>Contact Name---Telephone---E-mail---Contact Name---Telephone---Email---etc.
  </code></pre>