How To Add Ordering To SQL For graph

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

Guest

I have the SQL used for the RowSource of a Graph object in Access. It is
currently sorting by personnel (ascending order).

I would like to sort it in descending frequency order of personnel. Can
someone please help.

Here is the SQL statement:

TRANSFORM Sum([O_Rept#111_RP by Personnel].NoPers) AS SumOfNoPers
SELECT [O_Rept#111_RP by Personnel].Personnel
FROM [O_Rept#111_RP by Personnel]
GROUP BY [O_Rept#111_RP by Personnel].Personnel
ORDER BY [O_Rept#111_RP by Personnel].RnPa DESC
PIVOT [O_Rept#111_RP by Personnel].RnPa;


Thank You

Gary
 
I would like to sort it in descending frequency order of personnel.
What field would that be?
 
NoPers

I want the NoPers to order in from largest to smallest.


Gary

KARL DEWEY said:
What field would that be?
--
KARL DEWEY
Build a little - Test a little


Gary said:
I have the SQL used for the RowSource of a Graph object in Access. It is
currently sorting by personnel (ascending order).

I would like to sort it in descending frequency order of personnel. Can
someone please help.

Here is the SQL statement:

TRANSFORM Sum([O_Rept#111_RP by Personnel].NoPers) AS SumOfNoPers
SELECT [O_Rept#111_RP by Personnel].Personnel
FROM [O_Rept#111_RP by Personnel]
GROUP BY [O_Rept#111_RP by Personnel].Personnel
ORDER BY [O_Rept#111_RP by Personnel].RnPa DESC
PIVOT [O_Rept#111_RP by Personnel].RnPa;


Thank You

Gary
Click to expand...
Click to expand...
 
Use a second query to order.
--
KARL DEWEY
Build a little - Test a little


Gary said:
NoPers

I want the NoPers to order in from largest to smallest.


Gary

KARL DEWEY said:
I would like to sort it in descending frequency order of personnel.
Click to expand...
What field would that be?
--
KARL DEWEY
Build a little - Test a little


Gary said:
I have the SQL used for the RowSource of a Graph object in Access. It is
currently sorting by personnel (ascending order).

I would like to sort it in descending frequency order of personnel. Can
someone please help.

Here is the SQL statement:

TRANSFORM Sum([O_Rept#111_RP by Personnel].NoPers) AS SumOfNoPers
SELECT [O_Rept#111_RP by Personnel].Personnel
FROM [O_Rept#111_RP by Personnel]
GROUP BY [O_Rept#111_RP by Personnel].Personnel
ORDER BY [O_Rept#111_RP by Personnel].RnPa DESC
PIVOT [O_Rept#111_RP by Personnel].RnPa;


Thank You

Gary
Click to expand...
Click to expand...
Click to expand...
 
Thank You.

I got it working !!!!


Gary




KARL DEWEY said:
Use a second query to order.
--
KARL DEWEY
Build a little - Test a little


Gary said:
NoPers

I want the NoPers to order in from largest to smallest.


Gary

KARL DEWEY said:
I would like to sort it in descending frequency order of personnel.
What field would that be?
--
KARL DEWEY
Build a little - Test a little


:

I have the SQL used for the RowSource of a Graph object in Access. It is
currently sorting by personnel (ascending order).

I would like to sort it in descending frequency order of personnel. Can
someone please help.

Here is the SQL statement:

TRANSFORM Sum([O_Rept#111_RP by Personnel].NoPers) AS SumOfNoPers
SELECT [O_Rept#111_RP by Personnel].Personnel
FROM [O_Rept#111_RP by Personnel]
GROUP BY [O_Rept#111_RP by Personnel].Personnel
ORDER BY [O_Rept#111_RP by Personnel].RnPa DESC
PIVOT [O_Rept#111_RP by Personnel].RnPa;


Thank You

Gary
Click to expand...
Click to expand...
Click to expand...
 
Back
Top