# How to Get Month Name From Date in MS Access Query

> To get a month name from a date in MS Access, go to the Create tab and select Query Design. Next, select your table, click Add Selected Tables, and enter the SQL into the Field row of a blank column. Finally, click the Run button.

Canonical: https://livedemo.ai/tutorials/how-to-get-month-name-from-date-in-ms-access-query/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3eeeab56e05a00fe6cfc/preview?step=1

## Steps

1. Go to the 'Create' tab.
2. Select 'Query Design'.
3. Select the table and click 'Add Selected Tables'.
4. In the Field row of a blank column, enter the SQL.
5. Run the query by clicking the 'Run' button.
6. That's it! By following these steps, you can get a month name from the date in MS Access.