how to sort table in access and save it (Update) in access ?

Question

hi

i have Database in access Id,Fname

i need to sort this database (by Id) and save the new sort (update the table)

how i can sort & update ?

thank's in advance

Answer 1

That is not how relational databases work. You can make ID the primary key, if it is not already, and mostly the table will appear in that order. If, however, you need the table to always appear sorted by ID, you will need to create forms, which is a more sensible approach.