Help with query

  • Thread starter Thread starter jez123456
  • Start date Start date
J

jez123456

Hi, I have a table with the following fields and data

Name Relevance
Thompson 6
Thompson 6
Thompson 4
Thompson 6
Parker 6

If I sort the data by Relevance, I get

Name Relevance
Thompson 4
Parker 6
Thompson 6
Thompson 6
Thompson 6

But what I want is

Name Relevance
Thompson 4
Thompson 6
Thompson 6
Thompson 6
Parker 6

Many thanks
 
Sort Descending By Name and descending by Relevance

Or Ascending by Name and Descending by Relevance

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Try this --
SELECT [YourTable].Name, [YourTable].[Relevance]
FROM YourTable
ORDER BY [YourTable].[Relevance], [YourTable].Name;
 
Back
Top