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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

still need help with query to search all tables!!

Status
Not open for further replies.
crankin

crankin

Technical User
Apr 15, 2001
2
US
I've given up on that one query that searches all the tables, I just can't get it to work. Is it possible to link all queries easily or without vba?
 
Sort by date Sort by votes
Not sure what you're looking for here but yes, you can base one query on the results of another. In the query design grid, hit the add tables button. Notice the queries tab.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Help with a Query. 1
Replies
8
Views
90
serino
serino
breezett93
  • Locked
  • Question
Brand new lock violations errors all over my database
Replies
11
Views
2K
dhookom
dhookom
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
2K
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
671
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top