I’m creating an MS 2007 Access database for my bills. Some bills are due on the 5th of every month and some are due on the 25th of every month. In a table, is it possible to have a column that will be populated via a form such as entering the due date as 10-25-12? And another column in the same table auto display “October 2012” (Month Due)? Same thing if I entered 10-5-12 the other column will display “October 2012”.
Thanks in advance