sorting one column based on another column

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Hi
karl
Sorry But i didn't get your question. I am new to Access. If you can explain
your question in detail I will be happy to reply.
Thnx
 
Back
Top