Multiple tables search
Good point. TblName would definitely elimiate the issue.
--
Marsh
MVP [MS Access]
nrgins via AccessMonster.com wrote:
I wonder if using "Table" would create problems, since it's a reserved word.
Maybe "TblName" instead?
Anyway, I liked your solution of using dynamic SQL to embed the search
criteria into each component of the union query. Must faster than creating a
union query and running a Select statement against it!
Marshall Barton wrote:
SELECT t1.name. "t1" As Table FROM t1
|