G Guest Oct 29, 2004 #1 Is it possible to change the Access accounts for annual periods such that a 12 month period is a fiscal year rather than a calendar one?
Is it possible to change the Access accounts for annual periods such that a 12 month period is a fiscal year rather than a calendar one?
R Rick B Oct 29, 2004 #2 What are you trying to do? In your queries where you specify the dates you can specify any range you desire. This could cover a fiscal year. You'd have to be more specific. Rick B
What are you trying to do? In your queries where you specify the dates you can specify any range you desire. This could cover a fiscal year. You'd have to be more specific. Rick B
G Guest Nov 1, 2004 #3 One example: For my client (don't ask me why) the month begins at 20th day of the previous month, so : Apr 2004 = 20/Mar/2004 to 19/Apr/2004 and the Fiscal Year begins at November of the previous year: 2005 = Nov/2004 to Oct/2005 So, in my queries (and some forms) I use: FiscalYear = Year(DateAdd("m", 3, [CalendarDate]-19)) FiscalMonth = Month(DateAdd("m",1,[CalendarDate]-19)) It was the only way I could find but It works pretty well ! Take care Mauricio Silva
One example: For my client (don't ask me why) the month begins at 20th day of the previous month, so : Apr 2004 = 20/Mar/2004 to 19/Apr/2004 and the Fiscal Year begins at November of the previous year: 2005 = Nov/2004 to Oct/2005 So, in my queries (and some forms) I use: FiscalYear = Year(DateAdd("m", 3, [CalendarDate]-19)) FiscalMonth = Month(DateAdd("m",1,[CalendarDate]-19)) It was the only way I could find but It works pretty well ! Take care Mauricio Silva
