Modification Needed

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

GROUP BY should come before ORDER BY

In SQL statements, the WHERE condition comes before the GROUP BY condition

Now I have wrote codes as

Code:

---

  str = "Select c,acccode,tittle,Count(vou_no)As vou_no,vou_no As balance,sum(qty*weight) As weight,Sum(qty)As qty from gpass where Date between '" & Me.first_date.Text & "' and  '" & Me.last_date.Text & "' group By acccode order By acccode"
        dt = GetTable(str)

---

but it shows this error message

Code:

---

Column 'gpass.c' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

---

The datatype of column c is char(1)

Please help

you should add it to the group by (and all the other columns)