Fiscal Years

[LA USER]

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?

 

[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

 

[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