The entire SQL command is"
Select Field Names From Table Name ORDER BY [/I]ID Field Name[I] ASC.
Select * From Customers Order By CustomerID ASC
or Select CustomerID, CustFirstName, CustLastName From Customers Order By CustomerID ASC
PS. Do you have to have the ASC? or is it default?