Customising Drop Shipping Previous Orders Screen

 

I can see that sds_ViewPast.asp uses a query to find orders as follows :-

 

query="SELECT DISTINCT orders.idOrder, orders.orderDate, orders.ord_OrderName, orders.OrderStatus, orders.pcOrd_PaymentStatus FROM pcDropShippersSuppliers INNER JOIN (orders INNER JOIN ProductsOrdered ON orders.idorder = ProductsOrdered.idorder) ON (pcDropShippersSuppliers.idproduct=ProductsOrdered.idproduct AND pcDropShippersSuppliers.pcDS_IsDropShipper = " & session("pc_sdsIsDropShipper") & ")  WHERE ProductsOrdered.pcDropShipper_ID=" & session("pc_idsds") & " AND ((orders.orderStatus>2 AND orders.orderStatus<5) OR (orders.orderStatus>6 AND orders.orderStatus<=9) OR (orders.orderStatus=10 OR orders.orderStatus=12)) ORDER BY orders.idOrder DESC;"

 

Can anyone give me any pointers as to how can modify this query so that it does not looks for archived orders ?

 

Many Thanks

Matt

 

For anyone interested...  there was another reason for hiding archived orders (other than trying to keep the drop shippers previous order screen tidy).

 

We have our drop shippers on manual notification because there are times when we want to ship the product ourselves instead of asking our supplier to drop ship it.  When we ship ourselves we obviously do not notify the drop shipper.  By archiving the order too after shipment it also does not confuse the drop shipper by showing the order on their previous orders log in screen.