Declare value based on date range without year

[newbieX]

I have about 10000 records and I need to set a value in a separate field if the dates fall between certain planting seasons. Year is irrelevant. Thus if a date falls between a certain range, the Seasons field is filled in with its appropriate planting season. I would prefer to do this via a query interface as it is only a 1 time deal.

Spring = 3/16 - 5/15
Summer 5/16-8/15
Fall 8/16-10/31
Everything else is Null



3/20/2015 and 4/16/2013 are both "Spring" in the Season field column
6/28/2011 and 8/1/2015 are both Summer, etc.
Ideas as to how I can do this?


Many thanks.

[June7]

Pull the month and day parts from the date value.

Format([fieldname], "mmdd")

Let x represent that expression:

Switch(x<="0315",Null, x<="0515","Spring", x<="0815","Summer", x<="1031","Fall", x<="1231",Null)

No need to populate field. This can be calculated when needed.