Why can I not rearrange the columns in my crosstab query?

W

wigla

I want to arrange the columns in a crosstab query (Access 2002) so that the
first name appears first, but when I try to drag the column in datasheet view
to a new location nothing happens. Why is this.

I have sorted the last name and then the first name in design view, and have
put another column before the last name column in design view, but the last
name column seem to be frozen in the first place in datasheet view.
 
D

Duane Hookom

Is this column a "Column Heading" or "Row Heading"? You should be able to
move Row Headings in the design view. If you want to move the Column
Headings, you need to set all the possible values in the order you want them
in the Column Headings property:
Column Headings: "Jan", "Feb", "Mar", "Apr", "May",....."Dec"
 
Top