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?

Actual		Result
Name	Jobid	Location	site	JobType		Name	Jobid	Comon	Location	site	JobType
John	178004	17-DHW	west	D		John	178004	178004	17-DHW	west	D
Dedy	198004	18-FEQ	east	D		Dedy	198004	178004	18-FEQ	east	D
Pop	259940	11-LOB	west	D		Pop	259940	259940	11-LOB	west	D
Jacob	279940	15-LOB	east	D		Jacob	279940	259940	15-LOB	east	D
Udhay	314563	21-TOS	west	L		Udhay	314563	314563	21-TOS	west	L
Ashish	334563	23-TOS	east	L		Ashish	334563	314563	23-TOS	east	L

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Waqas ali]

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