Solved How to display Table / Query arranged by ID number

[SalmanZeiad]

The problem is that it appears untidy and random

 

[Minty]

A table has no specific order, that what a query is for, to specify an order.

SELECT * FROM YourTable ORDER BY YourIDField ASC

 

[Ranman256]

use the query designer. it gets the sql correct for you.

 

[SalmanZeiad]

The problem is that it appears untidy and random

solved>>>
in query under filed wanted choose Ascending

 

[Minty]

solved>>>
in query under filed wanted choose Ascending

If you switch to SQL view in the query designer - you may see something very similar to the query posted in #2 ...