Search results

Thank you, and is it the same as in the Excel with Dim and end sub?

Hi, can anyone write me a complete code for making a new table, or better, to clear the contents from table "Append All Union" and append two tables named "Union 2/9 Append" and "Union 10/12 Append"? Would be very grateful, because I am new to his. I could make it in Excel VBA but this is...

@ Janr: I have tried this just now to see if it works, but it doesn´t work with my data. I have ID´s which end at level 4, level 7 or level 11.. depends on data. And if i put up 11 levels, i dont get the data from level 4 or 5 or 7 because he is trying to find them in level 11, and they are not...

Cimaters, I have this kind of a table. Ok if a get deeper into my tables, I have one basic table called "Reference data original" with Son_ID, dad_ID, Lelevs from 1-12 and MIS LVL4 column at the end, and from this table i make one more table with distinct values of MIS LVL4 column. And in...

Thank you guys for replying, but i think i made my question clear, i just wanted to know if there is a way i can put the two select statements into one without the union... and plog answered it nice and simple, so thanks to Plog! There is no way to put it together, so i am now trying to find...

Hi I have up to 12 levels, and the son of one level is the father of another level... and i did it with union, is works until 9th levl and then it just shows error that there are to many tables or querys... And with the append function i need like 66 querys and that is to much.

hi, does anyone know how can I combine these two select statements without the Union? Can it be made?

thanks guys, this helped a lot. and it is not a school project, I just didn´t want to opet a new post, because i have the same problem. thanks again!!

Ok, that didn´t quite help me :) I need the data to lookl like this: 183 ____95 _______5790 ____________5967 ____________3161 ____________7950 ____________151 ____________2502 _________________2501 _________________87 _______2517 And 183 is the first level, and so on. Any ideas...

Hi, i read this article, and for me it still didn´t help. Maybe because I have other data and his data keeps confusing me. Anyway i wonder how i could make a treeview of SON_ID and DAD_ID, and son-id is usually also the "parent" as it goes down. my data looks something like this any ideas???