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
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