Union Query - Is there any function like 'IF EXIST' ?

[adibob2005]

I am using a union query in for combining results from 2 linked tables as under:

SELECT * FROM TABLE1


UNION
SELECT * FROM TABLE2;

Now, I want that even if one of the table does not exist, the query should work i.e. it should return results from only one table.

Is there any function like 'IF EXIST' ?
Please help.
Regards

[goodguy]

... even if one of the table does not exist ...

If a table does not exist, your users will get an error message.
IF EXISTS is available with TSQL (SQL Server) but I could not find any reference to it in Access 2007 Help. Even then, EXISTS tests whether any records or value is returned, NOT if a table exists.

[ajetrumpet]

I am using a union query in for combining results from 2 linked tables as under:

SELECT * FROM TABLE1
UNION
SELECT * FROM TABLE2;

Now, I want that even if one of the table does not exist, the query should work i.e. it should return results from only one table.

do it in a form. write a vba conditional to execute either sql code or query objects, based on the existence. it's that simple.

[adibob2005]

do it in a form. write a vba conditional to execute either sql code or query objects, based on the existence. it's that simple.

Can you explain it to me as I have never done VBA programming ?.
Please provide a sample code.