it's simple but driving me nuts! the database has about 22 or so tables and I just need to search for values in the same field in all the tables but it just won't work.If anyone knows of a way to do this that I haven't tried (one that involves SQL), I'd be very grateful!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
query that searches in all the tables
- Thread starter querying
- Start date
In order to do this you'll have to loop through the tables collection of the given database, then loop in your field in each table.
Hit F1 and search for "Collections". You'll find some examples that you should be able to blend together. Most are VB code but it's really just copy/paste...
Gord
ghubbell@total.net
Hit F1 and search for "Collections". You'll find some examples that you should be able to blend together. Most are VB code but it's really just copy/paste...
Gordghubbell@total.net
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
