How do I set the fiscal year?

's Computer Specifications

I need to run a report based on a fiscal year beginning in October showing
quarters by their number (1-4). How do I set Access 2000 so the fiscal year
begins in October instead of January? Thanks.

's Computer Specifications

To push the Oct, Nov, and Dec values into the following year, add 3 months
to the date, e.g.:
Year(DateAdd("m",3, [InvoiceDate]))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve" <(E-Mail Removed)> wrote in message
news:42BD9864-A802-4FBF-A2AE-(E-Mail Removed)...
>I need to run a report based on a fiscal year beginning in October showing
> quarters by their number (1-4). How do I set Access 2000 so the fiscal
> year
> begins in October instead of January? Thanks.

's Computer Specifications

Allen, thank you very much. That was a big help!

"Allen Browne" wrote:

> To push the Oct, Nov, and Dec values into the following year, add 3 months
> to the date, e.g.:
> Year(DateAdd("m",3, [InvoiceDate]))
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Steve" <(E-Mail Removed)> wrote in message
> news:42BD9864-A802-4FBF-A2AE-(E-Mail Removed)...
> >I need to run a report based on a fiscal year beginning in October showing
> > quarters by their number (1-4). How do I set Access 2000 so the fiscal
> > year
> > begins in October instead of January? Thanks.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calendar year versus fiscal year	mePenny	Microsoft Excel Misc	4	17th Nov 2009 06:05 PM
displaying the months on a graph by fiscal year not calendar year	SMT	Microsoft Access Queries	1	11th Feb 2008 10:59 PM
Help dealing with a fiscal year rather than a calendar year	=?Utf-8?B?VHlsZXI=?=	Microsoft Excel Worksheet Functions	3	25th Aug 2007 11:26 AM
To automatically give fiscal period/fiscal year	Turnipboy	Microsoft Excel Discussion	7	19th Jan 2006 09:14 PM
Grouping data by fiscal year not calendar year	Ted Hall	Microsoft Access	1	26th Nov 2003 11:36 AM