Hello Everybody

I use these code but this returns following error message

Incorrect syntax near the keyword 'group'.


Code:
str = "Select c,acccode,acc_name,title,Count(vou_no)As vou_no,vou_no As balance,	sum(qty*weight) As weight,Sum(qty)As qty from gpass	order By acccode group By acccode where Date between '" & Me.first_date.Text & "' and  '" & Me.last_date.Text & "'"
        dt = GetTable(str)
What is wrong, please modify