I need some fields in my form to auto populate with the current Fiscal Month and Week based on a table.
In Excel I created this very easy by doing a vlookup on a table I built based on WeekNum and matching those weeks up with the fiscal months and weeks.
How can I do this in access and have it do it automatically when someone enters a new record based on the Created Date.
Thanks,
In Excel I created this very easy by doing a vlookup on a table I built based on WeekNum and matching those weeks up with the fiscal months and weeks.
How can I do this in access and have it do it automatically when someone enters a new record based on the Created Date.
Thanks,