Oftentimes, transactions have been captured by a date.  However, when doing summary reports or analysis, we may want to use months.  Some tools such as Pivot Tables in Excel or Crosstab queries in Access can break down the data in months from a date. Even so, there are other instances when we simply need the month names to be extracted into another column.  The TEXT function can produce the month name using the “MMMM” specification.  See the syntax below and the illustration to extract a month name from a date.

 

NOTE:  If you want an abbreviated month, then use “MMM” (3 M’s, instead of 4).