month recognition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jenn Frisbee - 27 Aug 2004 14:59 GMT

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

Reply to this Message

Nikos Yannacopoulos - 27 Aug 2004 15:13 GMT

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

> I am trying to designate certain months to update records
> and can't find a way to get Access to recognise months. I
[quoted text clipped - 7 lines]
> Thanks,
> Jenn

Reply to this Message