If statement in query based on control value

[wokkie]

Hi,

I am using a parameter query in Access based on values on a form.

I want to use an if statement to determine which part of the query is ran.

i.e.

if forms!frm.control = "this" then
select * from tbl
else select * from tbl2

How do I do this?

Thanks

Ian

 

[ZmrAbdulla]

If you have Northwind database with you, check how they have done to run reports. If you have any doubt please come back


Zameer Abdulla

http://www.geocities.com/zameerabd/