I have a 'very' long query written through MS Access with lot of unions (around 30) and other dynamic variables.
Now, I need to insert a 'Where' clause in all those unions, and the where clause would be constant and generated through a form (selecting some options, I have written a vb code to create a string containing the where clause.
Is there any way I could use some variables in the SQL query so that the variable gets the where clause from the text result of the form action?
Illustrative: My Query
Select a,b,c,d from (select x as a,b,c,d from abc <where clause> union select y as a,b,c,d from abc <where clause> union select z as a,b,c,d from abc <where clause> union select p as a,b,c,d from abc <where clause>) order by a
The should be populated with the text box result which would look something like 'where b=1'
I thought of writing it in the VB code itself, but to numerous linebreaks and chaning nature of the queries, I do not want to manually keep adding " & _ at the end of each line.
Any help would be greatly appreciated.
Regards, Navs
Bookmarks