Crosstab Row Sorting in Alphabetical Order

I have a report based off of a crosstab query that the data under the columns
is text. I am trying to sort them in alphabetical order and keep them lined
up. I have the rank (count) in the report under the grouping section to sort
in ascending order but it sorts the text backwards, when I change it to
decending it will sort the longest column in order but the smaller columns it
puts at the bottom of the column instead of starting at the top.

Following is the code for the Crosstab:

SELECT Table_Customer.PrimaryID,
Query_Customer_Catalog_Crosstab_Final.builderid,
Query_Customer_Catalog_Crosstab_Final.neighborhood id,
Query_Customer_Catalog_Crosstab_Final.categoryid,
Query_Customer_Catalog_Crosstab_Final.categorydesc ription,
Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription,
Query_Customer_Catalog_Crosstab_Final.rank,
Query_Customer_Catalog_Crosstab_Final.S,
Query_Customer_Catalog_Crosstab_Final.U2,
Query_Customer_Catalog_Crosstab_Final.U3,
Query_Customer_Catalog_Crosstab_Final.U4,
Query_Customer_Catalog_Crosstab_Final.U5,
Query_Customer_Catalog_Crosstab_Final.U6
FROM Table_Customer INNER JOIN Query_Customer_Catalog_Crosstab_Final ON
(Table_Customer.NeighborhoodID =
Query_Customer_Catalog_Crosstab_Final.neighborhood id) AND
(Table_Customer.BuilderID = Query_Customer_Catalog_Crosstab_Final.builderid)
GROUP BY Table_Customer.PrimaryID,
Query_Customer_Catalog_Crosstab_Final.builderid,
Query_Customer_Catalog_Crosstab_Final.neighborhood id,
Query_Customer_Catalog_Crosstab_Final.categoryid,
Query_Customer_Catalog_Crosstab_Final.categorydesc ription,
Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription,
Query_Customer_Catalog_Crosstab_Final.rank,
Query_Customer_Catalog_Crosstab_Final.S,
Query_Customer_Catalog_Crosstab_Final.U2,
Query_Customer_Catalog_Crosstab_Final.U3,
Query_Customer_Catalog_Crosstab_Final.U4,
Query_Customer_Catalog_Crosstab_Final.U5,
Query_Customer_Catalog_Crosstab_Final.U6;

I'm not an advanced user so you might have to step me through what I would
need to do.

Any ideas or suggestions that you could give is really appreciated. I am
using Access 2007.
--
Alison