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
--
Message posted via
http://www.accessmonster.com