pivot table sort on crosstab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a form that automatically creates a query based on user input, then a
crosstab query from that first query. everything works great. but i would
like to be able to sort the crosstab columns according to other criteria, for
example, my crosstab creates student names as rows and assignments as column
headers and the student scores are the values in the crosstab. I would like
to be able to sort the assignments according to the date they were assigned
instead of alphabetically, which is how it is sorted automatically. it
tested and it is possible to sort it in descending order but it seems like
that's the extent. even though i sort the assignments by due date in the
first query, in the crosstab process, the columns for the crosstab are
re-sorted alphabetically. help???
 
The only way that you can position the columns in a crosstab query datasheet
is to set the Column Headings property of the crosstab. For instance, the
months would normally appear:
April, August,...
You could set your column headings property to:
January, February,...
 
Back
Top