Desending order of values

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I have set up a query that sums my attributes by shift.

SELECT tblProdTesting.Shift, Sum(tblProdTesting.Width1) AS
Width, Sum(tblProdTesting.Treat) AS Treat, Sum
(tblProdTesting.[Bag Length]) AS [Bag Length], Sum
(tblProdTesting.Gauge) AS Gauge, Sum
(tblProdTesting.FilmOpen) AS [Film Open], Sum
(tblProdTesting.Perforation) AS Perforation, Sum
(tblProdTesting.[Side Seam]) AS [Side Seam], Sum
(tblProdTesting.BottomSeal) AS [Bottom Seal], Sum
(tblProdTesting.EdgeWeave) AS EdgeWeave, Sum
(tblProdTesting.[Vent Holes]) AS [Vent Holes], Sum
(tblProdTesting.Other) AS Other
FROM tblProdTesting
GROUP BY tblProdTesting.Shift;

What I need now is how do I get my attributes to show in
desending order based off of the value? It would look
something like this:

EdgeWeave 10
Perforation 9
Other 8
Vent Holes 6

I am stumped on this.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the ORDER BY clause in the query. E.g.:

....
ORDER BY column_name DESC

DESC = descending (highest value to lowest value)


MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQD02soechKqOuFEgEQJzQgCdFhlF1qWM5wbgQrqcAkZTfDmHvvQAoK+f
TVfl3fk0x7P95yRTQBxf5SYa
=kCPU
-----END PGP SIGNATURE-----


Eric wrote:
 
Back
Top