How do I set the fiscal year?

[Guest]

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.

 

[Allen Browne]

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]))

 

[Guest]

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

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.

Reply to group, rather than allenbrowne at mvps dot org.

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.