Crosstab

[turks67 via AccessMonster.com]

How can I create a crosstab query that shows fiscal year from October to
September on a report?

 

[John W. Vinson]

How can I create a crosstab query that shows fiscal year from October to
September on a report?

If FY 2010 started on October 1, 2009, you can use a query criterion of

= DateSerial([Forms]![YourForm]![Desired FY], -2, 1) AND < DateSerial([Forms]![YourForm]![Desired FY], 10, 1)

Use the Crosstab Wizard to set up your crosstab query, using this expression
on the relevant date field (with WHERE as the Totals operator).

 

[trevorC via AccessMonster.com]

This is how the standard properties are for a normal crosstab query using
months as headers.
"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"

Leave your query the same just change the output columns.

select properties for the query and adjust the headings to suit your
requirements

To :-

"Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"

 

[turks67 via AccessMonster.com]

How do I put the year with the month?

This is how the standard properties are for a normal crosstab query using
months as headers.
"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"

Leave your query the same just change the output columns.

select properties for the query and adjust the headings to suit your
requirements

To :-

"Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"