CODE
Private Sub Command1_Click()
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "Select * from Authors WHERE Author ORDER by 'g*[e-o]'"
Adodc1.Refresh
End Sub
Private Sub Command2_Click()
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "Select * from Authors order by Author ASC"
Adodc1.Refresh
End Sub
Private Sub Command3_Click()
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "Select * from Authors order by 'T'"
Adodc1.Refresh
End Sub
this is my code in vb...my teacher told me to sort the authors. First in ascending order second in the authors should start from T and last all the the authors will start from G followed by and o. With that code.. Only the ascending appears correctly.. Can you help me? please i really need your help..Thankz. Ill attach the photo of my work... I am a beginner.Please help me. See the photo of my work. My codes for authors that starts with G and With T isnt working... Please help... I owe you a lot thank you so much!!
29 Sep, 2008 - 08:44 PM
| 