Putting dates on a form in access

[edmundson]

I have a form were I enter information every day. I have a two fields where I enter a month 2003 01 and the quarter 2003 01 (Where the 2003 is the year and 01 is the month and also have a field for the four quarters 2003 01). Is there a way to let the program automatically put the date into the field in that manner; and. I only have to change the information at the beginning of each month or quarter.

Thanks for any help,
Barry E

 

[striker83716]

Set the format of the month field to "yyyy mm", and set the format of the quarter field to "yyyy q".

You can go one step further and set the default value to (Now()) this will automatically enter the date for you each time you add a new record