gabepcsolutions
asked on
QUERY AND SYNTAX
I need to add to this query a sort filter, by Case Number, from highest number of CaseNumber to lowest:
SELECT CaseNumber, TypeCase, Category, CaseRep, [ Last Name ], [ First Name ], DriverLicense, SignUpDate, SignedBy, Address, City, State, Zipcode, Telef_Home, Telef_Cell, Telef_Work,
FROM dbo. [ Clients List ]
WHERE (Status IS NULL)
SELECT CaseNumber, TypeCase, Category, CaseRep, [ Last Name ], [ First Name ], DriverLicense, SignUpDate, SignedBy, Address, City, State, Zipcode, Telef_Home, Telef_Cell, Telef_Work,
FROM dbo. [ Clients List ]
WHERE (Status IS NULL)
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.