title: Ms Access how to get the day name in ms access sql query ie. Tuesday
body: <p>I would like to include the name of the day in my query in ms access?
  I know how to do it from the query designer in the format field as 'dddd', but want to rather add it in the sql editor as part of my statement.</p>
  
  <p>Its part of a select, from, where, group by, order by statement where the date is specified in the where clause but i want it to display as the name of the day ie Tuesday in another column.</p>
  
  <p>Thanks</p>