View Single Post
  #7  
Old June 6th, 2010, 07:34 PM posted to microsoft.public.access.queries
nrgins via AccessMonster.com
external usenet poster
 
Posts: 3
Default Multiple tables search

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