crosstab query and quarters (1 Viewer)

[jesseb]

Can I make a crosstab query go more than 4 quarters at a time. For example, I have information for quarters 1,2,3,4 of year 2001 and also quarter 1 of year 2002. Can I have the crosstab query pick that up somehow?

Thanks

 

[araskas]

Once you build your cross-tab query open the query in design view and change the column
Expr1: "Qtr " & Format([MyDate],"q") to
Expr1: "Qtr " & Format([MyDate],"yyyy/q")
Where Expr1 is the column heading.


[This message has been edited by araskas (edited 03-08-2002).]

 

[jesseb]

thanks a lot. I knew it was going to be something like that.