Keep Query Order Results View As Entered In The Sql View Using Access 2007

How do I keep the query order results as in the sql view the same. I use the following sql to obtain the results SELECT TableName.NumBR FROM TableName WHERE NumBR = '' OR NumBR Li

Solution 1:

You have not selected an order, you have created a where statement. You can use a temporary table with an autonumber for your criteria, then you can use the autonumber for your order.

SELECT TableName.NumBR
FROM TableName
INNER JOIN temp 
ON TableName.NumBR = Temp.NumBR
ORDER BY Temp.ID