Complicated Query

[khanhly246 via AccessMonster.com]

hi all

I want to write a query in MS Access2003 for Search feature in my application,
I try to write it like a store proceduce in SQL server but I don't know how,
somebody help me,
ex : can i use If ... esle , form and control objects in the code or just use
Select , insert , update, ...

help me, ASAP thanks
best regard !

 

[John Vinson]

hi all

I want to write a query in MS Access2003 for Search feature in my application,
I try to write it like a store proceduce in SQL server but I don't know how,
somebody help me,
ex : can i use If ... esle , form and control objects in the code or just use
Select , insert , update, ...

SQL/Server uses the T-SQL programming language in which you can mix
programming constructs and SQL constructs. Access JET SQL does not.

You can write VBA code with programming constructs, SQL queries with
(just) SQL constructs, and you can execute the queries from the code
(or call VBA functions from the query) - but no, you cannot write
mixed languages.

John W. Vinson[MVP]