Query in access not returning correct result due to join? -

i'm having bit of difficulty wrapping head around queries need joined correctly each other, in order correct result.

basically got database sewage network in it, network has manholes ids , pipes ids, pipes defined 1 upstreammanholeid (opstroemknudeid) , downstreammanholeid (nedstroemknudeid) (knude table = manhole).

when try make query based on observations in pipe, keep getting same pipeid listed pipes different upstream , downstream id. shown in picture below, because checks upstream manhole id before choosing pipe id.

i tried changing query, returns blanks in pipeid instead.

to sum up, need list pipeid based on both upstream , downstream node, is, can check either upstream or downstream. i'm having hard time explaining, feel free ask clarifying questions need.

at moment i'm running 2 queries, 1 calling other, in order correct result.

select tvinspektion.startpunktnr opstrømsknudenavn, tvinspektion.slutpunktnr nedstrømsknudenavn, knude.id op, knude_1.id ned (tvinspektion left join knude on tvinspektion.startpunktnr = knude.knudenavn) left join knude knude_1 on tvinspektion.slutpunktnr = knude_1.knudenavn;  select [copy of vurderes].op, [copy of vurderes].opstrømsknudenavn, [copy of vurderes].ned, [copy of vurderes].nedstrømsknudenavn, ledning.id [copy of vurderes] left join ledning on ([copy of vurderes].ned = ledning.nedstroemknudeid) , ([copy of vurderes].op = ledning.opstroemknudeid); 

that returns following result: