month recognition

[Jenn Frisbee]

I am trying to designate certain months to update records
and can't find a way to get Access to recognise months. I
just want to type the month into the field in the table
and be able to sort the records by month, having it start
with January etc - is this possible in Access? I know I
could just leave it in alphabetic order or use numbers
instead, but was wondering if Access has a built-in
function for months.

Thanks,
Jenn

 

[Nikos Yannacopoulos]

Jenn,

One workaround that I useis the following; I have a small table like:

M_ID M_Name
1 Jan
2 Feb
3 Mar
etc.

Then I use a combo on my form to select the month (so the user doesn't have
to type the month at all). The combo's rowsource is this table, and I set
Number of Columns = 2, Bound Column = 1, Column Width = 0;1. This results in
the user only seeing the second column (month names), while the combo
actually returns the month number, which is also what I store in my tables
instead of the month name, so my sorting is right. In forms, reports etc.
where I want the month name displayed, I simply include the table in the
RowSource query and get the name field, or use a DLookup.

HTH,
Nikos