0

Yet another MS Access Question!

I have a simple query where a quick left join is made to find relations of parts. My question is how can I loop this left join to continue until I end up with a empty column (As shown in the image)? The final column is full of nulls, so perhaps a check for that?

Also, As you can see in the Design view, I am using the results from a previous query (TXDGetLinks is the original, TXDGetLinks_1 is the first copy) to obtain results for the current search. How can I systematically add queries until the final column is found to be null?

If VBA is required, can someone please provide examples, I am afraid I am not very good with VBA.

Thanks!

Query Results: View of Query Results

View of Design for Query

Tanishq dubey
  • 1,522
  • 7
  • 19
  • 42
  • 1
    There's no JetSQL construct to do this, and No VBA construct to use a union operator on an existing result set. The performance is going to be poor at best by grabbing the next tier's values and adding a new section to a dynamic SQL string, and execute when you finally don't get results back. Access is a small-scale dbms and not meant for this. – Jaaz Cole Jun 23 '14 at 18:28
  • 1
    http://access.mvps.org/access/queries/qry0023.htm – tbur Jun 23 '14 at 19:19
  • What is your join column here? – Roland Jun 24 '14 at 05:22
  • OBJECT_ID2 is doing a left join with OBJECT_ID1 from GetLinks to GetLinks_1 – Tanishq dubey Jun 24 '14 at 15:56

0 Answers0