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

help make ONE query select for all data from all tables

Status
Not open for further replies.
RDC

RDC

Programmer
Jan 6, 2001
55
US
does anyone know how or if there is a way to make ONE query select statement for all data from all tables that exist in an access.mdb...



 
Sort by date Sort by votes
open new query in design view, on the table / query select window add all your tables

then go thru and add all the fields.

or is this not what you mean?
 
Upvote 0 Downvote
I painstakingly DID go thru that process... and it wouln't take it.. it exceeded limit..any ideas..
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
360
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
272
TrekBiker
TrekBiker
PrimoSteve
  • Locked
  • Question
Grid From 1
2
Replies
21
Views
1K
PrimoSteve
PrimoSteve
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
237
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
225
PrimoSteve
PrimoSteve

Part and Inventory Search

Sponsor

Back
Top