Recent Question Revisited - SELECT * FROM
Posted on 2001-07-08
I recently asked a question concerning this line:
Set rst = mydb.OpenRecordset("SELECT * FROM People WHERE Name LIKE 'Tim*' ", dbOpenDynaset)
Okay, so I am able to search the People table for the appropriate records that include the letters Tim. One step further, how would I search the entire database (Multiple tables) for the same 3 letters?