Sort by...

Results 1 to 2 of 2

Thread: Sort by...

  1. #1
    Join Date
    Dec 1969

    Default Sort by...

    I hope you can help me with this.<BR><BR>I have a sql string used with MS Access...<BR><BR>TRANSFORM Count([Defect Groups].[Complaint Number]) AS xx SELECT [Defect Groups].Expr1, Count([Defect Groups].[Complaint Number]) AS [Total Of Complaint Number] FROM [Defect Groups] GROUP BY [Defect Groups].Expr1 PIVOT [Defect Groups].[Cost Center]<BR><BR><BR>I want to sort by [Total of complaint Number] that is no a field if you can see my sql string.<BR><BR>Thanks for any help or links

  2. #2
    Join Date
    Dec 1969

    Default RE: Sort by...

    you can user the sort by clause after your group by clause.<BR>as long as your column that you wanted to sort is from one of the tables that you used in your select statement. If it&#039;s from a different table then you need to include the table in your selected statement then used it in the order by

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts