Hi all,

I have taken responsibility for an access database that appears to work well. It has been updated from Access 2 and is now 2003.

I have 2000 items in the database with about 12 individual field names. The field name ID is the primary key and is on autonumber.

My problem is that when I view a standard report that shows each item on a single page (with their field names) I would expect the ID numbers to be numerical. It appears that they are so, however the last 50 numbers are not at the end but near the end (about 30 numbers in).

I cannot see anything that would do this, if anyone could give me some advice it would be greatly appreciated.

Regards

K
;)

if the rows are sorted by ID they should be in order, if sorted by something else then the IDs might not be in order. bear in mind that if a row is deleted, the ID is gone and not replaced (unless you do some other things) so there could be some "missing" IDs in the list. hth. p.s. welcome to awf.

Many thanks for the welcome ;)
Is there anyway that I can see if the rows have been "sorted" in some way, that may not be obvious?
Regards

K
;)

Infact there are only 16 pages out of order. To give an idea, the numbers run from 1 to 1828, 1846 to 1933 and finally 1829 to 1843!
Its driving me mad!
K
:)

Found answer - Details as follows:
Reports > Design View (nothing selected working only on the Report) > Data Tab
Changed :
Filter On: No
Order By: ID (or what ever you require)
Order By: On

Now all is fine!

Hope that helps someone else!

Many thanks

K
;)

great. glad you got it sorted out and thanks for posting back!