Missing Syntax

[Heather]

Can anyone see what I am missing?

My original statement was this,

sql = "select TERR1,CATEGORY from tbl_ivo_ytd group by
TERR1,CATEGORY order by TERR1"

Needed to add month year part..

sql = "select TERR1,CATEGORY from tbl_ivo_ytd group by
TERR1,CATEGORY order by TERR1 where TRADE_MONTH = " & m
& " And TRADE_YEAR = " & y & ""

 

[Alex Dybenko]

first should be WHERE part, then ORDER