Query to sort list

[access2010]

Hello, I have tried using Sort Ascending in our Query, but am not successful in the sorting of the Stock_Name.

SELECT Investments01_tbl.Stock_Name
FROM Investments01_tbl
ORDER BY Investments01_tbl.Stock_Name;

===
Could a change be made to the code [Event Procedure] below to sort by Stock_Name

Private Sub Web_Links_Q_Click()
DoCmd.OpenQuery "StockName_Q"
DoCmd.Maximize
End Sub

===
Thank you
Nicole

 

[theDBguy]

Hi. Can you show us your data? I don't understand why the sorting is not working.

 

[access2010]

Hi. Can you show us your data? I don't understand why the sorting is not working.

Thank you for your note, theDBguy

We have deleted the Queries and forms that had caused us sorting problems.
Recreated these queries and forms and now our sorting's are working.

Thank you.
Crystal.