title: Query to select data between two times?
body: <p>I'm working with Microsoft Access and SQL</p>
  
  <p>I'm trying to select records from table between two times: 6:00:00PM and 11:59:00PM.</p>
  
  <p>Right now I have </p>
  
  <pre><code>SELECT RESERVATION.Reservation_ID, SEAT_RESERVED.Reservation_Time 
  FROM RESERVATION 
  INNER JOIN SEAT_RESERVED ON RESERVATION.Reservation_ID = SEAT_RESERVED.Reservation_ID 
  WHERE timestamps SEAT_RESERVED.RESERVATION_TIME between ('6:00:00PM' and '11:59:00PM'); 
  </code></pre>
  
  <p>But this isn't working and the error says it's missing an operator. Please help</p>