title: Display result of query in columns instead of lines
body: <p>I have a table looking like this :</p>
  
  <pre><code>Company | FCurrency | ... | FDate      | FAmount
  aaa     | EUR       | ... | 01-01-2014 | 5
  aaa     | EUR       | ... | 01-02-2014 | 8
  aaa     | EUR       | ... | 01-03-2014 | 9
  aaa     | EUR       | ... | 01-04-2014 | -2
  aaa     | USD       | ... | 01-01-2014 | 1
  aaa     | USD       | ... | 01-02-2014 | 2
  aaa     | USD       | ... | 01-03-2014 | 3
  aaa     | USD       | ... | 01-04-2014 | 4
  </code></pre>
  
  <p>And I would like to write a query which result would be something like :</p>
  
  <pre><code>Company | FCurrency | ... | 01-01-2014 | 01-02-2014 | 01-03-2014 | 01-04-2014 |
  aaa     | EUR       | ... | 5          | 8          | 9          | -2         |
  aaa     | USD       | ... | 1          | 2          | 3          | 4          |
  </code></pre>
  
  <p>I found a way to do it in VBA in excel but it takes a long time (because I have many many records) so I thought if access can do it for me it is much better.</p>
  
  <p>In access i found this post : <a href="https://stackoverflow.com/questions/6651097/displaying-multiple-columns-from-a-single-column-select-statement">Displaying multiple columns from a single column select statement</a> but it does not do what I want as it still outputs only one record per line, instead of merging them into one line.</p>
  
  <p>Also to merge the currency and company, I know how to do with GROUP BY, but my problem is to have the different 'new' columns, and I have to admit I am a bit lost there.</p>
  
  <p>Thanks in advance.</p>
  
  <p>V.</p>