Internally, Access represents the date/time data type as a special type of
real number, where the integer part represents the date, and the fraction
part the time (as a part of a day.) Therefore it is not possible to record a
date that consists of year and month only (no day.)
Best choice would probably be to store the first of the month, and format it
how you wish.
Another viable choice would be to use 2 fields of type Number (size
Integer): one for the year, one for the month.
Careful though: don't use names like Date, Time, Year as field names.
They're all reserved words:
http://allenbrowne.com/AppIssueBadWord.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Thorben Grosser" <th*************@gmail.comwrote in message
news:11**********************@o61g2000hsh.googlegr oups.com...
Hey again newsgroup,
I am still working on an archive database and got another problem: I
have to classify the folders by a date or a date range which has the
format mm/yyyy
I got the feeling, that I should try at every price to also use the
date/time field as it offers many benefits like easy searching or
automatic controlling of values.
As mm/yyyy is none of the regular types, I got several possibilities:
- Creating an own date system (integer or string, converted into
yyyymm format for easy search) with the disadvantage of not having a
date field
- Working around by transforming the mm/yyyy to eg. 01/mm/yyyy (which
would be fine for them I suppose)
- Finding a possibility for native mm/yyyy support.
Neither google nor the F1 key gave very much information on that
specific subject, so I#m askking
thanks in advance
Thorben Grosser