title: How to use cross join in access?
body: <p>Using MS - ACCESS 2003</p>
  
  <p>Table </p>
  
  <pre><code>S.No   Details
  
  1      name
  2      address
  3      email
  4      phone
  5      fax
  </code></pre>
  
  <p>and so on...,</p>
  
  <p>I want to combine all the details for the s.no’s. Like</p>
  
  <p>Expected Output</p>
  
  <pre><code>S.No Details
  
  1    name
       address 
       email
       Phone
       Fax
  2    address
       name
       email
       phone
       fax
  3    email 
       name
       address
       phone
       fax
  4    phone
       name
       address
       email
       fax
  5    fax
       name
       address 
       email
       Phone
  </code></pre>
  
  <p>and so on..,</p>
  
  <p>Cross join is not accepting in access 2003? Any other solution for this.</p>
  
  <p>Need query help.</p>