Query to show the status of Work Order




In my database table "tblOperation" there are field called Date, WorkOrder,Operation, Status, StaffNo etc. In the field Operation employees records the daily activity against each WorkOrder. One WorkOrder may completes in aday or more. If a WorkOrder needs to be continued for the next day employee set the status of that WorkOrder to "IP", if completed then set to "C". Ultimately each WorkOrder has to be completed and status to be marked as "C".. So there are WorkOrder status "IP and "C" as shown below. My aim is to make a query to filter out WorkOrders which doesn't have status set to "C"

Date WorkOrder Operation Status
28/1/2015 235 Test job IP
28/1/2015 236 Test job IP
28/1/2015 237 Test job IP
28/1/2015 238 Test job IP
29/1/2015 235 Test job IP
30/1/2015 235 Test job C
30/1/2015 237 Test job C
30/1/2015 236 Test job IP
31/1/2015 236 Test job IP
In the above table WorkOrder 235 & 237 are having status "IP" and "C". Where as WorkOrder 236 & 238 are only having status "IP". Kindly help me to make a query bring the WorkOrder list which is having "IP" status only.

Thanks and regards


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Status Query 3
Department Incomplete Work Order query 1
Order Query 3
Query Order By then By... 4
ORDER BY in queries 1
select status in a query 1
Status update query 1
Union query with ORDER in VBA doesnt work 12