associates
IS-IT--Management
Hi,
I was wondering if anyone would be able to tell how to sort date of type text in Access database?
The date that is of type text is stored in the table in the following format
1-August-2005 instead of 1/8/2005.
But when i press a button "sort By date in desc", it gives me
7-November-2005
3-October-2005
2-November-2005
29-August-2005
My code for the button "sort By date in desc" is as follows
strSQL = "SELECT DISTINCTROW Salary.Sal_ID, Staff_register.First_Name, Staff_register.Last_Name, Salary.Staff_ID, Salary.Date "
strSQL = strSQL & "FROM Salary INNER JOIN Staff_register ON Salary.Staff_ID=Staff_register.Staff_ID "
strSQL = strSQL & "ORDER BY " & col & " " & xorder
Me!List0.RowSource = strSQL
Me!List0.Requery
YOur help is very appreciated. Thank you in advance
I was wondering if anyone would be able to tell how to sort date of type text in Access database?
The date that is of type text is stored in the table in the following format
1-August-2005 instead of 1/8/2005.
But when i press a button "sort By date in desc", it gives me
7-November-2005
3-October-2005
2-November-2005
29-August-2005
My code for the button "sort By date in desc" is as follows
strSQL = "SELECT DISTINCTROW Salary.Sal_ID, Staff_register.First_Name, Staff_register.Last_Name, Salary.Staff_ID, Salary.Date "
strSQL = strSQL & "FROM Salary INNER JOIN Staff_register ON Salary.Staff_ID=Staff_register.Staff_ID "
strSQL = strSQL & "ORDER BY " & col & " " & xorder
Me!List0.RowSource = strSQL
Me!List0.Requery
YOur help is very appreciated. Thank you in advance