title: Syntax error in date in query expression for non-date fields
body: <p>I'm having trouble building a query in Access 2013. The database isn't mine and the only thing I really have control over is this query. There is a table, I'm pulling 7 fields from it and eventually adding an 8th field to the query to do some string manipulation.</p>
  
  <p>However, I keep getting getting "Syntax error in date in query expression 'fieldname'." error whenever I click on the arrow to sort the fields. The odd thing is these errors pop up when sorting non-date fields. When sorting the date field I get "Syntax error (missing operator) in query expression 'Release Date'."</p>
  
  <p>This happens after a fresh build. I have no WHERE conditions, just SELECT and FROM. Ideas?</p>
  
  <p>Here's the sql query, though I'm mainly working in the query design view:</p>
  
  <pre><code>SELECT Transmissions.[Job#], Transmissions.[Part#], Transmissions.TransmissionSN, Transmissions.Status, Transmissions.[Release Date], Transmissions.[Build Book Printed], Transmissions.[ID Tags Required]
  FROM Transmissions;
  </code></pre>