In my experience, Access sorts these columns by alphabetical order. In
cases like your's, I'd prepend the customer's name with "1) ", "2) ", etc.
so you have:
Customer Name Rev per year
1) Cust-B $2000
2) Cust-A $1500
3) Cust-C $1000
(If you have more than 9 customers then you'll need to use "01)", "02) ",
etc). You can get this by doing something like:
SELECT
CStr(COUNT(rpy2.*) + 1) & ") " & rpy1.[Customer Name] AS [CNAME],
rpy1.[Rev per year]
FROM
RevPerYear rpy1
LEFT JOIN RevPerYear rpy2 ON
rpy1.[Rev per year] < rpy2.[Rev per year]
Of course, this will break if any 2 or more customers have the same Rev per
year - you'll get the correct sorting but you'll have some duplicates and
some breaks in your "1)", "2)", etc. numbers. But if you're ok with all of
this, then you can build a crosstab like:
mth 1) Cust-B 2) Cust-A 3) Cust-C
1 33 12 77
2 223 33 3354
3 55 11 55