Sort function not working correctly

[kristyspdx]

I have a repoort with a field called center number on which the report is sorted--ascending . The report has been correctly sorted in the past, but now I have added some new center numbers to it and it is no longer correctly sorting. For example, the report now looks like this:

4-20-430-9622
4-20-700-9652
4-20-711-9602
4-20-100-6172


4-20-100-6202
4-20-100-6282
4-20-100-9222
4-20-100-9232

The top three center numbers are new and are out of order. The rest have been on the report for awhile and remain in order. The new center numbers were added to a master list in Excel (along with all the old numbers) and imported into Access. Any ideas on why the new numbers are out of order & how I can fix them?

[pbaldy]

Is the sorting set up in Sorting and Grouping? It has to be; if it's not, you may just have been lucky before.

[kristyspdx]

I figured it out. Thanks.