Have you ever wanted to just pull the month from a date in your Microsoft Access tables? Here is a quick and easy way to do this using the Month function built into access.
Below is the table we are going to be using:
We will convert the DATE column into a Month column and pull the Month, the number, instead of the full date string. Here is the syntax for Month:
Month ( date_value)
Pretty simple huh? Just put the name of the column into the date_value. Open up a query maker window and drag over the tables you want to query. Select the fields you want and then set up your date field like this:
When you run this query you will get just the month.
Comments are closed.