DUAL Table in Msaccess for adding rows to a query result using Union (1 Viewer)

[baba]

How to add my own rows to a query in MsAccess ?

I would like to do something like this:
Select Name from Table 1 where age > 75
Union Select "Joe" from Dual;

Expected Result: If Joe is not found in Table 1 ,then it would be added to the result of the query.
How can I do it in MsAccess as it does not use " DUAL" table. Thanks for the help!

 

[WayneRyan]

baba,

Just create a table named Dual, with ONLY one row:

Dual
----
Field1 Text(1)

Put an 'x' in the field.

That should do it.

hth,
Wayne

 

[baba]

Thanks it works!