thanx for suggestions.

but I got solution for my Prob.

I rewrite query as "SELECT this, that, theother FROM mytable Where 1=1"

thanx once again

SPD

in my project I am building up a SQL query according to multiple controls on the form

Dim strSQL As String

strSQL = "SELECT this, that, theother FROM mytable WHERE TRUE"

which will...

Can u give me VB code for try catch block??

I am still finding the solution for my prob.

thanx

SP

thanks AJ Ahrens !!