Ordering Columns in a Cross Tab Query & Dividing a Value

[Guest]

Hello,

First question, is there a way to specify what order the columns appear in a
cross tab query?

Second, is there a way to distribute a value in one column of a cross tab
query across new columns? For example, if I have a total value of a
contract, but I needed to recognize revenue equally in each of the three
months of a quarter, is there a way to distribute that value across columns
in a cross tab?

Thanks!

 

[Guest]

First question, is there a way to specify what order the columns appear in
a cross tab query?
In the SQL view edit the PIVOT line to something like this (Make sure the
results will match one of the entries or it will not display) ---
PIVOT HB_ALL.Cash_Flow In ("Jan", "Feb", "Mar",
"Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

Or you can get fancy like this --
PIVOT IIf(Hour([Date open]) Between 0 And 5,"0 - 5",Right("0" & Hour([Date
open]),2));

PIVOT Format([Date],"yyyy - mm - mmm");

PIVOT Format([Date],"Short Date");