hi,
Hi all,

I want to write a stored procedure in MS Access 2007, which will have 'If else condition'

example:

if (@flag=0)
Select * from Table1;
else if (@flag=1)
Select * from Table2;
else
Select * from Table3;

How can i write the Stored Procedure in MS Access 2007, which will give me the above output?

Thanks in advance....

the quetion that I would like to ask here is what are you trying achieve:

here is a simple example:

I have a text Box Text1 based on its value i will change the row source of a Combobox in the form Combo1. The code is attached to a command button:

Dim strSQL as String

If Me.Text1=1 then
strSQl="Select * From Table1"
elseid Me.Text1=2 then
strSQL="Select * From Table2"
Else
strSQL="Select * From Table 3"
End if

Me.Combo1.RowSource=strSQL

__________________
How to Mark a thead solved:
http://www.accessforums.net/forum-su...lved-1828.html

Contact
for Solutions to your database problems and at affordable rates
silverback_bats@yahoo.co.in

hi,
in above query 'flag' will be assigned runtime in c#.net application and Access is my backend.
As per the 'flag' value i want to fetch data from different table.