Order of fields in crosstab query

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

Guest

I have made a crosstab query and set the 'column headings' property of the
query to have all the possible values. The query works but the order that the
columns appear in is not the same as the order defined in 'column headings'.
How can I get the columns to appear in a desired order?
 
I'm guessing that you have at some time or other reordered the columns in
the datasheet view.

Probably the easiest way to fix the problem is
--Open the existing query in SQL view.
--Copy the SQL statement
--Close the existing query
--Open a new query.
--Paste the SQL you have copied into the SQL view of the new query.
--Run the query and see if you get the desired result.
--If all is good, save the new query (with a new name or with the old query
name)
 
Hi,



Use a form to see the result, rather than the query designer, is a possible
solution for you?


Hoping it may help,
Vanderghast, Access MVP
 
Thanks.
I also have a totals coulmn in my query which totals all the values in all
colums in a row. This column has a crosstab category of 'row heading'
selected in the design view. This column appears first before all the 'column
headings' defined in that property. Is there a way to force this column to
the end (right most).
 
You can't display the Row Heading to the right of the derived columns. You
would need to create a new, select query if this was important to you.
 
Back
Top