[yr4icka_85]

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!!

[DilutedImage]

Sorry, but I won't do your homework for you. I'll throw you a bone though. .. First, learn the correct way to use ORDER BY. Second, learn about the LIKE statement. W3Schools and Tizag are good places to start. Don't just jump to those sections though – read from the beginning. They're quick and easy, and will give you a good foundation in SQL statements.

2¢

[no2pencil]

I have a bookmark for W3schools just for their SQL syntax.

[yr4icka_85]

no2pencil, on 30 Sep, 2008 - 12:46 AM, said:

I have a bookmark for W3schools just for their SQL syntax.

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

[yr4icka_85]

no2pencil, on 30 Sep, 2008 - 12:46 AM, said:

I have a bookmark for W3schools just for their SQL syntax.

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

[dlkirk03]

http://www.w3schools...sql/default.asp

[DilutedImage]

yr4icka_85, on 30 Sep, 2008 - 02:05 AM, said:

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

Your question has been answered. Have you not read anything provided? Stop being lazy. Go read.

[yr4icka_85]

DilutedImage, on 30 Sep, 2008 - 10:16 AM, said:

yr4icka_85, on 30 Sep, 2008 - 02:05 AM, said:

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

Your question has been answered. Have you not read anything provided? Stop being lazy. Go read.

ok!you dont need to be like that...im sorry...

[yr4icka_85]

yr4icka_85, on 1 Oct, 2008 - 08:20 PM, said:

DilutedImage, on 30 Sep, 2008 - 10:16 AM, said:

yr4icka_85, on 30 Sep, 2008 - 02:05 AM, said:

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

Your question has been answered. Have you not read anything provided? Stop being lazy. Go read.

ok!you dont need to be like that...im sorry...

hey!!i got it...harhar...thnx a lot...where can i find basic game tutorial in vb 6.0...tnx

[DilutedImage]

It got you to read.

Now as for "basic game", that's an oxymoron.

[jjsaw5]

yr4icka_85, on 1 Oct, 2008 - 11:53 PM, said:

yr4icka_85, on 1 Oct, 2008 - 08:20 PM, said:

DilutedImage, on 30 Sep, 2008 - 10:16 AM, said:

yr4icka_85, on 30 Sep, 2008 - 02:05 AM, said:

can you help me in the code for sorting it with g then followed by e then o?any clue for the clause that will be used..thnx!

Your question has been answered. Have you not read anything provided? Stop being lazy. Go read.

ok!you dont need to be like that...im sorry...

hey!!i got it...harhar...thnx a lot...where can i find basic game tutorial in vb 6.0...tnx

On the internet! Go to google and search for "VB 6.0 game tutorials" not that hard.