Handeling months in access

Whilst I am early on in the project can any one please give me a bit of
advice on handling months in a simple data base.
what the month field needs to do is just list the month but I do need to
run checks on the date later on to see if some action is due.
My question is
What type of field should I use number ,date etc

and then do some code to test the field later?

Ta Jon

re: Handeling months in access

On Mon, 2 Feb 2004 19:28:08 -0000, "Jon" <jthef@connectfree.co.uk>
wrote:
[color=blue]
>Whilst I am early on in the project can any one please give me a bit of
>advice on handling months in a simple data base.
>what the month field needs to do is just list the month but I do need to
>run checks on the date later on to see if some action is due.
>My question is
>What type of field should I use number ,date etc
>
>and then do some code to test the field later?
>
>Ta Jon
>[/color]

Jon,
To display either just the month number or the month name of a Date
datatype field, in the Form or Report control's Format Property line
write:
m
to get just the month number, 2
or
mm
to get the 2 digit month number, 02
or
mmm
to get a 3 letter short name, Feb
or
mmmm
to get the full name, February

Since this only effects how the control displays, it will have no
effect on using the field for any thing else you might need.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email

re: Handeling months in access

"Jon" <jthef@connectfree.co.uk> wrote in message news:<401ea66d_1@mk-nntp-2.news.uk.tiscali.com>...[color=blue]
> Whilst I am early on in the project can any one please give me a bit of
> advice on handling months in a simple data base.
> what the month field needs to do is just list the month but I do need to
> run checks on the date later on to see if some action is due.
> My question is
> What type of field should I use number ,date etc
>
> and then do some code to test the field later?
>
> Ta Jon[/color]

Use a date field. then you can use Month() Year() Time() and all
those fun functions to get the piece you want.