Sorting from Query

[3535]

I have a form based on a Query. One field is checked marked decending sort. The records on my from do NOT show sorted. I am new to Access 2000. Any ideas where I might be going wrong?<br>
<br>
<br>

 

[elizabeth]

Are any of the other fields marked sort? Perhaps that field is not your primary sort. It works left to right if there are multiple sorts.

 

[culshaja]

Have you put a sort on the form which would override the query sort?<br>
<br>
James

 

[3535]

Culshaja,Had put a sort on the form, but it is removed. <br>
Elizabeth,No. There are 3 tables with no other sorts.<br>
Please send me any other ideas.

 

[elizabeth]

Usually my first step in troubleshooting would be to run the query independently, to see if that is working correctly. If not, and you can't find the error, you could paste the SQL in here for us to see.

 

[DougP]

Go to your report in Design view and click 'View', 'Sorting & Grouping'<br>
then click under Field/Expression<br>
You will see a list of all of the fields<br>
Pick the one in question<br>
Then right next to it click Sort Order pick Ascending or Descending<br>
Good Luck<br>
<br>
DougP<br>