:) you can use some SQL tools(such SQL Server's Query Analyzer) which can chech you SQL statement, go, if you SQL statement is right that you can see the result for you query. My English is not good, but I can try my best for your problem.:cool: hi

:cool:Use CRecordset Open() member function.