date format in table

[Guest]

i am a new user to access.. i have created three tables and forms for these
tables. i do not need the dates to reflect mm/dd/yyy, what i need is just
mm/yyyy.

my question is what would the format be in the table input mask to make this
possible?

any help would be appreciated. thanks

 

[Ken Snell [MVP]]

If you just want to store mm/yyyy, then you probably don't want to use the
Date/Time data type for the field in the table. Instead, you could use a
text field to store the string (prone to data entry errors, and you'd need
to have programming to properly parse the various entry formats).

It would be better to use two integer fields, one to store the month and one
to store the year. Then your user would enter the month and year separately,
you store them separately, and then can combine them at any time in a
display in the desired format. Much cleaner data will result this way.

 

[Guest]

I would go ahead a store the data as a date. Tables are only for the storage
of data. When you want to display it for a human, use a format to display
it like you want it seen. In this case, it would be format(date, "mm/yyyy").