Sorting Problem

[Drunkenneo]

I have written a query where it displays sorted data for two columns, but problem is its sorting on one column but not on another

When checking the query seperately its giving proper output, but in form view its sorting only on one column not on another. Please help

 

[DavidAtWork]

have you checked the form's sorting/grouping to see if you have anything set there as this will overide any sorting in your query.

David