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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Loop through all tables and create unmatched query

Status
Not open for further replies.
proteome

proteome

Technical User
May 14, 2003
115
US
Is it possible to loop through all of the tables in an Access database and do unmatched queries against one another. If you have 4 tables you would have

1 vs 2
1 vs 3
1 vs 4


Thanks
 
Sort by date Sort by votes
sure... I think you need to use the tabledef's collection of the database object (but it has been years since I used access - thank god!)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
CREATE msflexgrid as in xlsx file 2
Replies
8
Views
549
strongm
strongm
sal21
  • Locked
  • Question
loopimg link and downlosd zip file 1
Replies
3
Views
368
strongm
strongm
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
513
Andrzejek
Andrzejek
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
1K
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
COUNT all items in trteeview in last level 1
Replies
4
Views
499
2009luca
2009luca

Part and Inventory Search

Sponsor

Back
Top