Simple month fieldq

[Aldersgate]

Seems so simple, but can't figure out how to create a field that will simply show the month and can be sorted by month. Tried numbers, tried text, looked all over internet; all complex answers. Help!

[NTC]

make a query of your table and when in design view after add fields you want, then create a new calculated field:e.g.
MonthName: Month([YourDateFieldNameHere])

then you can set it to sort this column

hope this helps.

[SoftwareMatters]

You could create a seperate table called Months with 2 fields ID and Month as follows:

MonthID = Number
MonthDesc = Text

Data in the table as follows:

ID, Month
1 January
2 February
3 March
etc, etc

Then you can sort on the ID field and link to the table to choose the month.