How to Get Month Name From Date in MS Access Query

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to extract a month name from a date in MS Access Query.

Quick summary

To get a month name from a date in an MS Access query, you use the Query Design view to add a custom SQL expression in the Field row that converts a date value into its corresponding month name. This method works directly within Access without requiring any external tools or macros.

Steps

Go to the Create tab in MS Access.
Select Query Design to open the query builder.
Select your table and click Add Selected Tables to add it to the query.
In the Field row of a blank column, enter the SQL expression to extract the month name from the date field.
Run the query by clicking the Run button.
The query results will display the month name extracted from the date field for each record.

📌 Why this matters

Extracting a month name from a date in an MS Access query is a common need for users building reports, filtering records by month, or grouping data for analysis. MS Access does not have a built-in MonthName display in simple table views, so using a SQL expression in Query Design gives users precise control over how date data is formatted and presented. This technique saves time for database administrators and business analysts who need readable, month-based reporting without exporting data to Excel. Knowing how to write this query directly in Access improves productivity and reduces dependency on manual data manipulation.

Your product deserves an interactive demo

Start free

How to Integrate a Microsoft Excel Database with Excel

How to Integrate Google Calendar with an MS Access Database

How to Integrate Google Sheets with an MS Access Database