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!

create query on 2 existing ADO querys ??

Status
Not open for further replies.

CPUburn

Programmer
Jan 18, 2001
146
BE
hi,

I'm having a problem with a complicated ado query. I'm accessing an access database in which i need data from many different tables, resulting in just one dataset. Problem is, it is impossible to get all of the data i need in just 1 query, so in access I created 2 query's, on which I created a third query, returning the desired dataset.

=> is there a way of creating the first 2 ADOquery's directly on the access tables, and a third ADOquery which gets it's data from the 2 first querys?

thx in advance,
CPUburn
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top