[AccessD] Multiple Table Search

Jim,

Thanks for the reply.  How about where myTable can be any of 70+ tables and
myFieldName can be any field within those 70+ tables?

Mark



-----Original Message-----
From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] 
Sent: Monday, July 26, 2004 3:58 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Multiple Table Search


Mark

select * from myTable where myFieldName like *Mark*

The previous sql should return all matches, from table myTable where the
word 'Mark' is anywhere in the field myFieldName.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark
S. (Newport News)
Sent: Monday, July 26, 2004 11:38 AM
To: [AccessD]
Subject: [AccessD] Multiple Table Search


Group,

Strange request, but I've been handed this db and am not familiar enough
with the data to do an educated search.   What is the simplest method to
find an instance of data amongst 70+ tables.

Mark
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com