modify crosstab query to fiscal qtrs rather than calandar qtrs

  • Thread starter Thread starter Lisacu
  • Start date Start date
L

Lisacu

I need to provide quarterly data based on our fiscal year, not the calendar
year. I am able to create a crosstab query, but don't know how to modify it
for our fiscal year. Thank you
 
Create a query with a new field that classifies the months into quarters and
use that as the source for the crosstab.
 
Thanks for the reply. Please explain more.

scubadiver said:
Create a query with a new field that classifies the months into quarters and
use that as the source for the crosstab.
Click to expand...
 
If you could provide more information about what you have already then my
response might be more constructive.

Presumably you are basing your crosstab on another table or query? Add the
following as an extra field in the query

Quarter: Format([datefield], "q")

It will then classify the dates into 1,2,3 or 4 starting from January. As
said, you can use that new field in the crosstab.
 
You're correct. I based the crosstab query on another query. And I have
already used Quarter: Format([datefield], "q"), which produced quarters from
Jan on, but my desire is for Q1 to reflect Jul-Sep, Q2 to reflect Oct-Dec,
and so on, based on our fiscal year Jul-Jun. Any ideas?

scubadiver said:
If you could provide more information about what you have already then my
response might be more constructive.

Presumably you are basing your crosstab on another table or query? Add the
following as an extra field in the query

Quarter: Format([datefield], "q")

It will then classify the dates into 1,2,3 or 4 starting from January. As
said, you can use that new field in the crosstab.



Lisacu said:
Thanks for the reply. Please explain more.
Click to expand...
Click to expand...
 
If you haven't already worked it out:

Q: IIf([Quarter]<3,[quarter]+2,[quarter]-2)


Lisacu said:
You're correct. I based the crosstab query on another query. And I have
already used Quarter: Format([datefield], "q"), which produced quarters from
Jan on, but my desire is for Q1 to reflect Jul-Sep, Q2 to reflect Oct-Dec,
and so on, based on our fiscal year Jul-Jun. Any ideas?

scubadiver said:
If you could provide more information about what you have already then my
response might be more constructive.

Presumably you are basing your crosstab on another table or query? Add the
following as an extra field in the query

Quarter: Format([datefield], "q")

It will then classify the dates into 1,2,3 or 4 starting from January. As
said, you can use that new field in the crosstab.



Lisacu said:
Thanks for the reply. Please explain more.

:
Create a query with a new field that classifies the months into quarters and
use that as the source for the crosstab.

:

I need to provide quarterly data based on our fiscal year, not the calendar
year. I am able to create a crosstab query, but don't know how to modify it
for our fiscal year. Thank you
Click to expand...
Click to expand...
Click to expand...
 
Back
Top