title: MS Access: Take all characters before the second space
body: <p>I'm working in MS Access. I have a field of names. Some of them have three names (their first, middle, and last). How would I write a query to extract all characters before the second space so that I will be left with just their first and middle name?</p>
  
  <p>If I have a name like John Joe Doe, I just want John Joe portion</p>
  
  <p>Any help would be appreciated. Thank You.</p>
  
  <p>Nick</p>