I have a large database with a query that is called "WOQuery" in it has lots of information for a manufacturing plant. The columns of importance are: WorkOrderNum, QtyOrdered, QtyShipped
Pretty much all I want it to do is get a list of WorkOrderNum's that are NOT complete. A WorkOrderNum is complete when QtyOrdered = QtyShipped. One thing to keep in mind is that there are almost 37,000 WorkOrderNum's.
My idea was that I was going to go to 1st record, check if QTYOrdered = QtyShipped, if true then go to next record, if false place WorkOrderNum in a new query then go to next record. Till N records are complete. Where N = the number of total records.
I just don't know if that's the "proper" way of accomplishing this task and I wanted to see if anyone else had a more brainiack idea.
Thanks,
-Saint
Pretty much all I want it to do is get a list of WorkOrderNum's that are NOT complete. A WorkOrderNum is complete when QtyOrdered = QtyShipped. One thing to keep in mind is that there are almost 37,000 WorkOrderNum's.
My idea was that I was going to go to 1st record, check if QTYOrdered = QtyShipped, if true then go to next record, if false place WorkOrderNum in a new query then go to next record. Till N records are complete. Where N = the number of total records.
I just don't know if that's the "proper" way of accomplishing this task and I wanted to see if anyone else had a more brainiack idea.
Thanks,
-Saint