C
Cam
Hello,
I am trying to create a query to capture the total count in each WC where
the operation corresponding to the WC vary and can be multiple operation per
WC.
The work center ref information is:
WC Operation
Heat 1 to 90
Cool 100
Inspect 110 to 130
QA 140
Super 150
Process 170 to 310
Assembly 320 to 500
I got several hundred data where an order# is at an operation. I need a
query to determine say if the order is at operation 1 to 90, then it count as
WC heat. I would like the query to summarize the total count in each WC.
WC Total count
Heat 35
Cool 12
Inspect 30
QA 20
Super 31
Process 50
Assembly 24
Thanks for any help.
I am trying to create a query to capture the total count in each WC where
the operation corresponding to the WC vary and can be multiple operation per
WC.
The work center ref information is:
WC Operation
Heat 1 to 90
Cool 100
Inspect 110 to 130
QA 140
Super 150
Process 170 to 310
Assembly 320 to 500
I got several hundred data where an order# is at an operation. I need a
query to determine say if the order is at operation 1 to 90, then it count as
WC heat. I would like the query to summarize the total count in each WC.
WC Total count
Heat 35
Cool 12
Inspect 30
QA 20
Super 31
Process 50
Assembly 24
Thanks for any help.