How To Add Ordering To SQL For graph

[Gary]

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

 

[KARL DEWEY]

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

 

[Gary]

NoPers

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


Gary

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

 

[KARL DEWEY]

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

NoPers

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


Gary

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

 

[Gary]

Thank You.

I got it working !!!!


Gary

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

NoPers

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


Gary

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