MS Access Adding in a new fiscal year to a current database

[zilla37]

Hi All,

I have been given the task to add in a new fiscal year to a current database.
I need help on how to go about adding one in. I did watch the someone do it last year but they no longer work here.
Below is how the fiscal is displayed.
I did remember that there was a screen where you could enter the number of days you would like for ex 10 and it would auto fill in.
You would do a small number to ensure there are no errors.
Can anyone recall how this is done?
I am sorry but I do not use Access very much and do not know the proper language.
Any help would be great.

CALENDAR_DATE	PERIOD_ID	WAREHOUSE_OPEN	PUBLIC_HOLIDAY	DAY_NUMBER_IN_PERIOD	BUS_DAY_NUMBER_IN_PERIOD	DAY_OF_WEEK
07-Dec-12	201309	Y		13	10	FRI
08-Dec-12	201309	N		14	10	SAT
09-Dec-12	201309	N		15	10	SUN
10-Dec-12	201309	Y		16	11	MON
11-Dec-12	201309	Y		17	12	TUE
12-Dec-12	201309	Y		18	13	WED
13-Dec-12	201309	Y		19	14	THU
14-Dec-12	201309	Y		20	15	FRI
15-Dec-12	201309	N		21	15	SAT
16-Dec-12	201309	N		22	15	SUN
17-Dec-12	201309	Y		23	16	MON
18-Dec-12	201309	Y		24	17	TUE
19-Dec-12	201309	Y		25	18	WED
20-Dec-12	201309	Y		26	19	THU
21-Dec-12	201309	Y		27	20	FRI
22-Dec-12	201309	N		28	20	SAT
23-Dec-12	201309	N		29	20	SUN
24-Dec-12	201309	Y		30	21	MON
25-Dec-12	201309	Y	Y	31	21	TUE
26-Dec-12	201309	Y	Y	32	21	WED
27-Dec-12	201309	Y		33	22	THU
28-Dec-12	201309	Y		34	23	FRI
29-Dec-12	201309	N		35	23	SAT
30-Dec-12	201310	N		1	0	SUN
31-Dec-12	201310	Y		2	1	MON
01-Jan-13	201310	Y		3	2	TUE
02-Jan-13	201310	Y		4	3	WED
03-Jan-13	201310	Y		5	4	THU
04-Jan-13	201310	Y		6	5	FRI
05-Jan-13	201310	N		7	5	SAT
06-Jan-13	201310	N		8	5	SUN
07-Jan-13	201310	Y		9	6	MON
08-Jan-13	201310	Y		10	7	TUE
09-Jan-13	201310	Y		11	8	WED
10-Jan-13	201310	Y		12	9	THU
11-Jan-13	201310	Y		13	10	FRI

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Joe4]

What you are talking about does not appear to be an inherent Access activity, I believe it is programmed process written specifically for that particular database (someone programmed a process to do that in your database). Without actually having access to your database to see how it is written and code behind it, I don't know that anyone will be able to help you.

Your best bet may be to try to track down the designer, or see if anyone else there is familiar with how the database works. Otherwise, you might need to find a consultant to take a look at it, or upload the database for someone to take a look at it (cannot attach file to this site).

Be very careful that if you do upload it for someone to check it out, that you first make sure that there is no proprietary information in the database! You may want to check with someone at your company first, lest you might get yourself into some trouble (we have seen it happen!).