Query to sort list (1 Viewer)

access2010

Registered User.
Local time
Today, 09:39
Joined
Dec 26, 2009
Messages
1,019
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

I’m here to help
Staff member
Local time
Today, 09:39
Joined
Oct 29, 2018
Messages
21,358
Hi. Can you show us your data? I don't understand why the sorting is not working.
 

access2010

Registered User.
Local time
Today, 09:39
Joined
Dec 26, 2009
Messages
1,019
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.
 

Users who are viewing this thread

Top Bottom