S SalmanZeiad Member Local time Today, 11:52 Joined Oct 30, 2017 Messages 112 Apr 20, 2021 #1 The problem is that it appears untidy and random
Minty AWF VIP Local time Today, 09:52 Joined Jul 26, 2013 Messages 10,666 Apr 20, 2021 #2 A table has no specific order, that what a query is for, to specify an order. SELECT * FROM YourTable ORDER BY YourIDField ASC
A table has no specific order, that what a query is for, to specify an order. SELECT * FROM YourTable ORDER BY YourIDField ASC
Ranman256 Well-known member Local time Today, 04:52 Joined Apr 9, 2015 Messages 4,354 Apr 20, 2021 #3 use the query designer. it gets the sql correct for you.
S SalmanZeiad Member Local time Today, 11:52 Joined Oct 30, 2017 Messages 112 Apr 21, 2021 #4 SalmanZeiad said: The problem is that it appears untidy and random Click to expand... solved>>> in query under filed wanted choose Ascending
SalmanZeiad said: The problem is that it appears untidy and random Click to expand... solved>>> in query under filed wanted choose Ascending
Minty AWF VIP Local time Today, 09:52 Joined Jul 26, 2013 Messages 10,666 Apr 21, 2021 #5 SalmanZeiad said: solved>>> in query under filed wanted choose Ascending Click to expand... If you switch to SQL view in the query designer - you may see something very similar to the query posted in #2 ...
SalmanZeiad said: solved>>> in query under filed wanted choose Ascending Click to expand... If you switch to SQL view in the query designer - you may see something very similar to the query posted in #2 ...