How to add my own rows to a query in MsAccess using Union,Dual Table

[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!

[johny10151981]

Your question is really confusing.

If you write a statement like this:

SELECT 1;
 

result would be 1

that is if you write something literal in select statement you will only get literal value. judge your question again and ask note below, then someone might be able to help you, but with this message nothing is clear