Problems Sorting Queries (1 Viewer)

[rabu5]

Here is my problem, maybe you all could help. I am running an update query for a list of companies. In my Table they are all in alphabetical order. However, when I run my query, they are sorted in some random order, probably the order which they were entered. I would like to sort the update query by alphabetical order of company. WHen I run the update, there is no mention of sort by company name anywhere. How do I do this? Its driving me nuts. Thank You.

 

[pdx_man]

An Update Query is an Action query. It does not need to be sorted. If you are looking at the query in the Datasheet View, it is just giving you a current snapshot of the fields in which an update will be made. After you have run your Update Query, view a Select Query that will allow you to view the data any way you want.

 

[rabu5]

Thank you very much...that works!