It really depends on whether you want to merely see the dates as April
2009, May 2009 etc, but still retain the ability to do date arithmetic
on the values. If you use a date/time data type you can still input
the date as May 2009, 2009 May or 2009/5, and it will be saved as 1
May 2009. You can them do date arithmetic on it so long as you bear
in mind that each date is in fact the first of the month in question.
This won't matter if doing something like getting the difference in
months between two dates using the DateDiff function for instance. To
see it as the month and year you simply format it as "mmmm yyyy"
The other option would be to use separate columns (fields) for the
year and month, but don't call the fields Year or Month as these are
the names of built in functions; use something specific like
TransactionYear. If you want to enter the month as a string make the
column a text data type, if a number use an integer number data type,
For the year use an integer number type.
You could use a single column for both year and month, of text data
type, but you'd then have to parse the value if you want to extract
the year only for instance, so two columns are a better bet.
If you do use separate columns you can still do date arithmetic but
you'll first have to convert the values to a date/time value, which
again would become the 1st of the month with an expression such as:
CDate([TransactionYear] & "/" & [TransactionMonth])
Ken Sheridan
Stafford, England