I created a form in MS Access Office 2007.
What I need to do, if possible, is have a field auto populate based on another field.
I need to enter the week ending of the year. There are 52 weeks in a year. So in the year 2012, 01/03/12 is in the first week of the year. If the user enters 01/03/12 in one field the other field should show “01” for example. I created a table with the entire 365 days (1/1/12 to 12/31/12) in one column and the week ending in the corresponding column.
Thanks in advance