title: Combine several records with 1 id into 1 record in Access
body: <p>I have the following collection of records.</p>
  
  <pre><code>lgh_driver1 | lgh_number | Origin Company ID | First Pickup Company ID | Second Pickup Company ID | First Drop Company ID | Second Drop Company ID | Ending Company ID | Event Time
  XXXXXX       111111        XXXXWAR                                                                                                                                       15
  XXXXXX       111111                            GORMC                                                                                                                     199
  XXXXXX       111111                                                      ERGCON                                                                                          944
  XXXXXX       111111                                                                                  QUASAL                                                              45
  XXXXXX       111111                                                                                                          QUASAL                                      45
  XXXXXX       111111                                                                                                                                   XXXXWAR            15
  </code></pre>
  
  <p>Ideally what I would like to do  is combine these so that i get 1 lgh driver 1 lgh number and all of the companies listed on one line with a sum of the event times. I am hoping that there is a relatively simple solution that I am overlooking but any solution will do at this point.  Any thoughts or comments would be greatly appreciated. Thank you.</p>