correct my error in query

[sonasiva]

iam getting the error as follows
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in FROM clause

following is the showing error

my_sql="SELECT company_name,[tran_date] FROM data as T"&"WHERE [tran_date]=(select max[tran_date] from data & where company_name=T. company_name)"

[shweta123]

Hi,

Hope you still need this,

try writing the query this way

my_sql="SELECT company_name,[tran_date] FROM data as T"&" WHERE [tran_date]=(select max[tran_date] from data & where company_name=T. company_name)"

Give spaces before Where clause.

Shweta

[iam_clint]

my_sql="SELECT company_name,[tran_date] FROM data T WHERE [tran_date]=(select max[tran_date] from data & where company_name=T. company_name)"