Data results out of order

A

alex

I made a access database form with fp03 and I had the results set for 36
entries and then it start a new page. I went pass that limit and then went
back to change it to show all results on the same page, it should be in order
of old to new but instead all new past are in the middle betweeen old and new
post how can I fix it without starting over?
 
J

John Vinson

I made a access database form with fp03 and I had the results set for 36
entries and then it start a new page. I went pass that limit and then went
back to change it to show all results on the same page, it should be in order
of old to new but instead all new past are in the middle betweeen old and new
post how can I fix it without starting over?
Click to expand...

That's not how tables work. An Access table is an unordered "bucket" of
data; Access will store records wherever there is room, sometimes at the end
of the table, sometimes not. And the records will be presented in whatever
order Access finds convenient.

The solution is to use a Query sorted by some field in the table's data.
This query can be edited and used as a source for a form, report, or page.

John W. Vinson
 
Top