sql="select "&tblname&".aaa,"&tblname&".bbb,"&tblname&".ccc,tblname2.ddd from "&tblname&",tblname2 where "&tblname&".aaa"=tblname2.aaa order by "&tblname&".aaa desc"
try:
sql="selec "&tblname&".aaa,"&tblname&".bbb,"&tblname&".ccc,tblname2.ddd from "&tblname&",tblname2 where "&tblname&".aaa"=tblname2.aaa order by "&tblname&".aaa desc"
try: