T
turks67 via AccessMonster.com
How can I create a crosstab query that shows fiscal year from October to
September on a report?
September on a report?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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).
T
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"
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"
T
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"