Quarterly report

[Guest]

I am new to Access and was wondering if there was a generic form for
reporting quarterly info by fiscal year, I am working in access 2000. Or is
there a way to set the whole system to use fiscal year dates. I've been told
to go to tools, select options then select calendar tab - but there is no
calendar tap - does any one have any advice. I know it's simple...

 

[Guest]

You did not say when your fiscal year was. This will give you a fiscal year
that runs May - April.

In your query in design view add a column with this --

Fiscal Year: DatePart("yyyy",DateAdd("m",-4,[YourDate]))

Use this as criteria --
[Enter Fiscal Year - 2001]

 

[Guest]

Quarterly year starts in Oct - Sept. Thank you, It looks generic so a minor
adjustment will work. I appreciate your assistance.
--
LLB

You did not say when your fiscal year was. This will give you a fiscal year
that runs May - April.

In your query in design view add a column with this --

Fiscal Year: DatePart("yyyy",DateAdd("m",-4,[YourDate]))

Use this as criteria --
[Enter Fiscal Year - 2001]

I am new to Access and was wondering if there was a generic form for
reporting quarterly info by fiscal year, I am working in access 2000. Or is
there a way to set the whole system to use fiscal year dates. I've been told
to go to tools, select options then select calendar tab - but there is no
calendar tap - does any one have any advice. I know it's simple...