I seem to have overlooked a feature of your question. You have several

sums in one row, and want to sort the *columns*. That cannot be done

with SQL.

You can, however, produce a large UNION of the sums, much like this:

first create a helpquery that puts your FROM and WHERE at bay:

[helpquery]

SELECT * FROM [Input] INNER JOIN DSAT ON Input.[Input ID] = DSAT.[Input ID]

WHERE (((Input.[Start Time])>=[Enter Start Date (mm/dd/yyyy)] And

(Input.[Start Time])<=[Enter End Date (mm/dd/yyyy)]))

then have a large set of UNIONS:

SELECT Abs(Sum(CommCon)), "Communication Content Error" FROM helpquery

UNION SELECT Abs(Sum(PerfWor)), "Performance Seems Worse" FROM helpquery

UNION SELECT Abs(Sum(AppPCWor)), "Application or PC not Working" FROM

helpquery

UNION SELECT Abs(Sum(PrinPeriph)), "Printer or Peripheral Problems" FROM

helpquery

and so on; in the end you can do

ORDER BY 1

meaning the first column. The second column will show your value label.

Dr******@gmail.com schreef:

Here's another question:

This output of the query gives me each number in a row ... doesn't

'group by' apply to columns?? can i even sory a row of data?

So my output it each Sum() has a column and produces on one row with

all the numbers. Can this be done?

If not, suggest a new way to do the calculations?!

Dr******@gmail.com wrote:
>Bas Cost Budde wrote:
>>Save your query, create a new query based on it and ORDER BY that one.

I'm still a bit confused on how to do this ... I have the query saved

... but i can't 'order by' a "*" , so how do i get all the columns in

order???

Sorry if this is an easy fix :-/

--

Bas Cost Budde

Holland