Sorting data in M$ Access

[theghost]

I am using the following statement in Access 2000.

SELECT tblCustomer.*
FROM tblCustomer
ORDER BY tblCustomer.db_str_company, tblCustomer.db_str_city;

The sorting is great for the customer name but does not sort on the second item which is the city. Most of it will be sorted by name then city but there are a few cities that are not in sorted order. Does anyone have an explanation or solution??? I have checked to makes sure that the names were correct ant that there were no spaces in front of the city names. Everything looks good. I have several customers that have plants in different cities. So i may have the same customer name with 10 different city names.

Thanks,

Jason

[theghost]

I think I may have found the problem.

Thanks,