Query only works if sorted correctly

[InstructionWhich7142]

Hi,

I have a query which works through a table of data, the data is interdependant, eg the value of a lower level is dependant on the top level and the query calculates these values

If I sort by level so the higher levels are calculated first it works, however I am unsure if this is reliable? if I use the result of this query in another query will that effect the results?

Thanks,