Access list indexing problem?

[theresa2332]

I have a customer database with name, address, zip, phone, email and last date purchase.

I run an unmatched query against the phone numbers to delete the customers I don't need to call. The list is sorted by my customers zip codes. Ususally, the query runs without any problems keeping the zip codes together. After I run the query, my list is sorted by the phone number not by the zip codes as desired, and the Client ID is not ascending any longer. I've tried deleting the phone indexing, with no results. I am a pretty new user of Access and any help would be appreciated. Thank You

 

[PHV]

Has your query an ORDER BY clause ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[theresa2332]

No order by clause, just a standard Unmatched Query.

 

[PHV]

So, you have your answer.
If you want a sorted list you have to tell the SQL engine the field(s) you want order by.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pbrodsky]

I'm assuming you created a query using the unmatched query wizard. There is no magic to the query produced. Just look at it in design view and fix it any way you want.