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!