Common Value

[Waqas ali]

Dear All,

i have a table named actual. i want to get in query as result.

from actual if Jobid last 4 digits are same than first value should come with second value.

example in result table is shown. i prepared it manually but i want to get through query.

how to write an query?

[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl68, width: 320, colspan: 5"]Actual[/TD]
[TD="width: 64"][/TD]
[TD="class: xl68, width: 384, colspan: 6"]Result[/TD]
[/TR]
[TR]
[TD="class: xl63"]Name[/TD]
[TD="class: xl63"]Jobid[/TD]
[TD="class: xl63"]Location[/TD]
[TD="class: xl63"]site[/TD]
[TD="class: xl63"]JobType[/TD]
[TD][/TD]
[TD="class: xl63"]Name[/TD]
[TD="class: xl63"]Jobid[/TD]
[TD="class: xl63"]Comon[/TD]
[TD="class: xl63"]Location[/TD]
[TD="class: xl63"]site[/TD]
[TD="class: xl63"]JobType[/TD]
[/TR]
[TR]
[TD="class: xl64"]John[/TD]
[TD="class: xl64"]178004[/TD]
[TD="class: xl64"]17-DHW[/TD]
[TD="class: xl64"]west[/TD]
[TD="class: xl64"]D[/TD]
[TD][/TD]
[TD="class: xl64"]John[/TD]
[TD="class: xl65"]178004[/TD]
[TD="class: xl65"]178004[/TD]
[TD="class: xl64"]17-DHW[/TD]
[TD="class: xl64"]west[/TD]
[TD="class: xl64"]D[/TD]
[/TR]
[TR]
[TD="class: xl64"]Dedy[/TD]
[TD="class: xl64"]198004[/TD]
[TD="class: xl64"]18-FEQ[/TD]
[TD="class: xl64"]east[/TD]
[TD="class: xl64"]D[/TD]
[TD][/TD]
[TD="class: xl64"]Dedy[/TD]
[TD="class: xl64"]198004[/TD]
[TD="class: xl65"]178004[/TD]
[TD="class: xl64"]18-FEQ[/TD]
[TD="class: xl64"]east[/TD]
[TD="class: xl64"]D[/TD]
[/TR]
[TR]
[TD="class: xl64"]Pop[/TD]
[TD="class: xl64"]259940[/TD]
[TD="class: xl64"]11-LOB[/TD]
[TD="class: xl64"]west[/TD]
[TD="class: xl64"]D[/TD]
[TD][/TD]
[TD="class: xl64"]Pop[/TD]
[TD="class: xl66"]259940[/TD]
[TD="class: xl66"]259940[/TD]
[TD="class: xl64"]11-LOB[/TD]
[TD="class: xl64"]west[/TD]
[TD="class: xl64"]D[/TD]
[/TR]
[TR]
[TD="class: xl64"]Jacob[/TD]
[TD="class: xl64"]279940[/TD]
[TD="class: xl64"]15-LOB[/TD]
[TD="class: xl64"]east[/TD]
[TD="class: xl64"]D[/TD]
[TD][/TD]
[TD="class: xl64"]Jacob[/TD]
[TD="class: xl64"]279940[/TD]
[TD="class: xl66"]259940[/TD]
[TD="class: xl64"]15-LOB[/TD]
[TD="class: xl64"]east[/TD]
[TD="class: xl64"]D[/TD]
[/TR]
[TR]
[TD="class: xl64"]Udhay[/TD]
[TD="class: xl64"]314563[/TD]
[TD="class: xl64"]21-TOS[/TD]
[TD="class: xl64"]west[/TD]
[TD="class: xl64"]L[/TD]
[TD][/TD]
[TD="class: xl64"]Udhay[/TD]
[TD="class: xl67"]314563[/TD]
[TD="class: xl67"]314563[/TD]
[TD="class: xl64"]21-TOS[/TD]
[TD="class: xl64"]west[/TD]
[TD="class: xl64"]L[/TD]
[/TR]
[TR]
[TD="class: xl64"]Ashish[/TD]
[TD="class: xl64"]334563[/TD]
[TD="class: xl64"]23-TOS[/TD]
[TD="class: xl64"]east[/TD]
[TD="class: xl64"]L[/TD]
[TD][/TD]
[TD="class: xl64"]Ashish[/TD]
[TD="class: xl64"]334563[/TD]
[TD="class: xl67"]314563[/TD]
[TD="class: xl64"]23-TOS[/TD]
[TD="class: xl64"]east[/TD]
[TD="class: xl64"]L[/TD]
[/TR]
</tbody>[/TABLE]

 

[Waqas ali]

Dear i want to do it in MS access query. how can i do in query?