Roll Days to a month in Access

[Mac1206]

I have a Shipping_day Column that I need to turn into months and need some help on how to obtain this goal please...Thanks in Advance...

Invoice	Invoice_Item	Shipping_Day
97749302	10	1/5/2017
97767388	40	1/10/2017
97767388	50	1/10/2017
97778915	90	1/4/2017
97793659	20	1/9/2017
97793660	20	1/11/2017
97793660	21	1/11/2017
97800777	20	1/5/2017
97807265	50	1/5/2017

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Result would be:
Group by Month:January, February, March, etc., instead of the short date above....

 

[stumac]

Within a query the Format$ function can be used to format a date into a month:

SELECT *, [COLOR=#0000FF]Format$(Shipping_Day,"mmmm") AS ShippingMonth [/COLOR]FROM [I][B]MyTable[/B][/I]

 

[stumac]

I should say that this function can also be used in reports, forms etc.

 

[Mac1206]

Within a query the Format$ function can be used to format a date into a month:

SELECT *, [COLOR=#0000FF]Format$(Shipping_Day,"mmmm") AS ShippingMonth [/COLOR]FROM [I][B]MyTable[/B][/I]

Thanks, that worked perfectly....

 

[james_lankford]

SELECT *,  month ( Shipping_Day ) AS ShippingMonth FROM MyTable

if the month number is good enough this will work too

and you probably won't notice, but format is slower