Hi, I have the following query which works fine in DESIGN mode. When I run the query details are sorted in OrganisationName as required. However, when I option to right click and select Open View it is NOT. Instead it sorts it with the first Field which is Primary key and ID (OrganisationID).. I dont understand this behaviour.. SELECT TOP (100) PERCENT dbo.tblOrganisation.OrganisationName, dbo.tblOrganisation.Country, dbo.tblOrganisation.LicenceEffectiveDate, dbo.tblOrganisation.LicenceExpiryDate, dbo.tblOrganisation.DateDisabled, dbo.tblOrganisation.CreationDate, dbo.tblCurrSelectedStatus.Curr_StatusFROM dbo.tblOrganisation INNER JOIN dbo.tblCurrSelectedStatus ON dbo.tblOrganisation.Status = dbo.tblCurrSelectedStatus.Curr_StatusORDER BY dbo.tblOrganisation.OrganisationName
Thank you