How do I set the fiscal year?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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, thank you very much. That was a big help!

Allen Browne said:
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.

Steve said:
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.
Click to expand...
Click to expand...
 
Back
Top