View Single Post
  #8  
Old June 6th, 2010, 08:05 PM posted to microsoft.public.access.queries
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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