Hello Friends I am facing a little problem that I want to sort my records according to date I mean to say
I want to show the upcoming records based on dates on the top in ascending order I have a complete working code to fetch from the database but I don’t know that why its not showing up according to my requirements here is my screenshot and database query.
I am using MS Access, VB6 and Listview for displaying all records
If rs.State = 1 Then rs.Close
sql = "SELECT * FROM tblHallBook WHERE book_complete='0' AND book_status='1' ORDER BY book_date ASC"
rs.Open sql, cn
ListView3.ListItems.clear