title: MS Access SQL query from 3 tables
body: <p>I have 3 tables shown below in MS Access 2010:</p>
  
  <p>Table: <strong>devices</strong></p>
  
  <pre><code>   id | device_id | Company | Version | Revision |
     -----------------------------------------------
     1  | dev_a     | Almaras | 1.5.1   | 0.2A     |
     2  | dev_b     | Enigma  | 1.5.1   | 0.2A     |
     3  | dev_c     | Almaras | 1.5.1   | 0.2C     |
  *Field: device_id is Primary Key Unique String
  *Field ID is just an auto-number column 
  </code></pre>
  
  <p><strong>Table: activities</strong></p>
  
  <pre><code>   id | act_id | act_date   | act_type | act_note |
     ------------------------------------------------
      1 | dev_a  | 07/22/2013 | usb_axc  | ok       |
      2 | dev_a  | 07/23/2013 | usb_axe  | ok       | (LAST ROW for dev_a)
      3 | dev_c  | 07/22/2013 | usb_axc  | ok       | (LAST ROW for dev_c)
      4 | dev_b  | 07/21/2013 | usb_axc  | ok       | (LAST ROW for dev_b)
  *Field: act_id contains device_id; NOT UNIQUE
  *Field ID is just an auto-number column 
  </code></pre>
  
  <p><strong>Table: matrix</strong></p>
  
  <pre><code>  id | mat_id | tc    | ts | bat | cycles |
    -----------------------------------------
    1  | dev_a  | 2811  | 10 | 99  | 200    |
    2  | dev_a  | 2911  | 10 | 97  | 400    |
    3  | dev_a  | 3007  | 10 | 94  | 600    |
    4  | dev_a  | 3210  | 10 | 92  | 800    | (LAST ROW for dev_d)
    5  | dev_b  | 1100  | 5  | 98  | 100    |
    6  | dev_b  | 1300  | 8  | 93  | 200    |
    7  | dev_b  | 1411  | 11 | 90  | 300    | (LAST ROW for dev_b)
    8  | dev_c  | 4000  | 27 | 77  | 478    | (LAST ROW for dev_c)
  *Field: mat_id contains device_id; NOT UNIQUE
  *Field ID is just an auto-number column 
  </code></pre>
  
  <p>Is there any way to query tables to get results as shown below (each device from devices and only last row added [see example output table] from each of the other two tables):</p>
  
  <p><strong>Query Results:</strong></p>
  
  <pre><code>device_id | Company | act_date   | act_type | bat | cycles |
  ------------------------------------------------------------
  device_a  | Almaras | 07/23/2013 | usb_axe  |  92 |   800  |
  device_b  | Enigma  | 07/21/2013 | usb_axc  |  90 |   300  |
  device_c  | Almaras | 07/22/2013 | usb_axc  |  77 |   478  |
  </code></pre>
  
  <p>Any ideas? Thank you in advance for reading and helping me out :)</p>