dorandoran
Programmer
Is there a VBA to create right join from table [ALL] to all the tables that resulted from qryTable using SSN ?
qryTables
SELECT DISTINCT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "msys*" And & _
(MSysObjects.Name) Not Like "all*") AND ((MSysObjects.Type)=1));
qryTables
SELECT DISTINCT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "msys*" And & _
(MSysObjects.Name) Not Like "all*") AND ((MSysObjects.Type)=1));