Modification Needed

[dot_lover]

Hello Everybody

I use these code but this returns following error message

Incorrect syntax near the keyword 'group'.

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

[motil]

GROUP BY should come before ORDER BY

[Pradeep1210]

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

[dot_lover]

Now I have wrote codes as

  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

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

[motil]

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