Id ten tango question

[ASKJesse]

An application I am working with has an Access 2007 database where the information is stored. I have gone into the .mdb file and I have sorted numbers in a column, to put them in order. The numbers, however, remain in their scrambled state when I open the application to view it.



How do I get what I see in the application to reflect the sequence in the updated table?

I am an ID10T so please spell it out for me.

[pbaldy]

Generally you don't worry about the order of records in the table itself. Think of it as a bucket holding the data. You sort the data when you view it, either on a form or report (as developers, we don't typically let users into the tables, just forms and reports). On a form, you can either use its Order By property or base the form on a query that has sorting. On a report, you specify the sort in Sorting and Grouping.

[ASKJesse]

Thanks for your prompt response.

On my particular application, I don't have the ability to sort on the user side of it, that is why I went into the .mdb. I was rooting around in there, looking for the forms and reports and can only find the tables. I really need to get the items back in order. The programmer who built the application is no longer part of the company.