G
Guest
Hi
Experts
I am generating a record for JOB Status report. brief overview will help
understand my requirement
The planner makes planning for every job he receives. he allocates job no.
to every job and the machine through which that job will pass.
I have 6 dept
say DEPT A, DEPT B, DEPT C, DEPT D, DEPT E, DEPT F.
currently I have generated a query and report which shows the flow of all
the jobs respectively from the dept which they have been planned to pass
through.
ex: JOB 1 passes through Dept A, Dept C, Dept D
Job 2 passes through Dept A, Dept B, Dept D, Dept E, Dept F
My report lists this correctly.
Morever I am able to show only those job no. which are passing through dept
B( which is job 2).
but what I want to achieve is """ report to list all the dept through which
that job 2 is passing ?""""
I don't want to list job 1 in my report coz it it not going through Dept B.
Bit tricky for me but might not be for all who r experts!!!!
Any right suggestion will be appreciated.
Thnx
Experts
I am generating a record for JOB Status report. brief overview will help
understand my requirement
The planner makes planning for every job he receives. he allocates job no.
to every job and the machine through which that job will pass.
I have 6 dept
say DEPT A, DEPT B, DEPT C, DEPT D, DEPT E, DEPT F.
currently I have generated a query and report which shows the flow of all
the jobs respectively from the dept which they have been planned to pass
through.
ex: JOB 1 passes through Dept A, Dept C, Dept D
Job 2 passes through Dept A, Dept B, Dept D, Dept E, Dept F
My report lists this correctly.
Morever I am able to show only those job no. which are passing through dept
B( which is job 2).
but what I want to achieve is """ report to list all the dept through which
that job 2 is passing ?""""
I don't want to list job 1 in my report coz it it not going through Dept B.
Bit tricky for me but might not be for all who r experts!!!!
Any right suggestion will be appreciated.
Thnx