Link to home
Start Free TrialLog in
Avatar of Newie_reporting_services
Newie_reporting_services

asked on

How to arrange data in your SQL statement

I have attached a PDF so you can see what I am talking about.

In the matrix I have Prospect Status and Rating Description.  How can I move around each field in the Rating Description.  Example

$1-$2999
$40000 - $50000

I want to arrange these in the correct order in the report or sql statement.


SELECT     DCons_ProspectStatus, DConRtng_RatingDescription, COUNT(DSol_ConstituentID) AS Expr1, DSol_ConstituentID, DSol_FullName
FROM         DR_SolicitorRelations
GROUP BY DCons_ProspectStatus, DConRtng_RatingDescription, DSol_ConstituentID, DSol_FullName

Open in new window

PMR1020-march-13.pdf
Avatar of roaks
roaks
You want to sort by count?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Newie_reporting_services
Newie_reporting_services

ASKER

I want to be able to arrange all the fields in this table    DConRtng_RatingDescription

Example of what lives in this table

5 - Rating
$100000 - $20,0000
WE - $5k to $10K

I would need to eye ball each field and then arrange in a certain way........... It can not be based on Asc or desending.