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...

[TABLE="width: 243"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Invoice[/TD]
[TD]Invoice_Item[/TD]
[TD]Shipping_Day[/TD]
[/TR]
[TR]
[TD]97749302[/TD]
[TD]10[/TD]
[TD]1/5/2017[/TD]
[/TR]
[TR]
[TD]97767388[/TD]
[TD]40[/TD]
[TD]1/10/2017[/TD]
[/TR]
[TR]
[TD]97767388[/TD]
[TD]50[/TD]
[TD]1/10/2017[/TD]
[/TR]
[TR]
[TD]97778915[/TD]
[TD]90[/TD]
[TD]1/4/2017[/TD]
[/TR]
[TR]
[TD]97793659[/TD]
[TD]20[/TD]
[TD]1/9/2017[/TD]
[/TR]
[TR]
[TD]97793660[/TD]
[TD]20[/TD]
[TD]1/11/2017[/TD]
[/TR]
[TR]
[TD]97793660[/TD]
[TD]21[/TD]
[TD]1/11/2017[/TD]
[/TR]
[TR]
[TD]97800777[/TD]
[TD]20[/TD]
[TD]1/5/2017[/TD]
[/TR]
[TR]
[TD]97807265[/TD]
[TD]50[/TD]
[TD]1/5/2017[/TD]
[/TR]
</tbody>[/TABLE]


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