Search results

Thank you, brother, but I already want the query to update other tables, which are the accounts table, and the time that this code takes is very long Look, this query, it will update the accounts every time the user enters an invoice and this is a very long time to add an invoice

Ok, I am very sorry, but it was a simple example, so you can understand what is meant

Note: the Nodes belonging to each other may be more than 15 Nodes

This code that I created is working correctly, you can see it, but it is very slow and I want a faster way

Mr. Majp, these are about 4,200 records if that helps

First, thanks to everyone for the interest. Secondly, this is a file that tells about the thing that I want, Mr. arnelgp your code. It did not help me because I need to collect the tree to the main Nodes main node is 1 , see this file plz, thank you

I tried to make this query from vba and SQL, but if the recordings are greater than 200 it becomes unreasonably slow.

ok, I do not want a treeview, I just want a query to calculate for me the recurring account for all my tables, and if it is as you say 5000 only need 10 seconds, this is wonderful

i have table like>> Parent_ID Acc_ID value 0 1 0 1 13 1 13 121 1 121 121001 1 0 2 0 2 23 1 23 131 1 131 131001 1 The output I want Parent_ID Acc_ID Value 0 1 3 1 13 3 13 121 2 121 121001 1 0 2 3 2 23 3 23 131 2 131 131001 1 What I want is unlimeted...