View Single Post
  #2  
Old June 25th, 2008, 02:37 PM posted to microsoft.public.access.queries
scubadiver
external usenet poster
 
Posts: 1,673
Default modify crosstab query to fiscal qtrs rather than calandar qtrs


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

"Lisacu" wrote:

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