Select Sales_Store, Sales_CtrNo, Sales_TransNo, Sales_OperId, Sales_RcptNo, Sales_CloseDate, Sales_Qty, Sales_Gross, Sales_SumDiscByMny, Sales_NetSales, Sales_Status, Sales_Shift, Sales_CustomerId, Sales_PriceLvl, Sales_Price_Shift, Sales_Tot_Cost, Sales_SalesPerson From Pos_Sales

Where Sales_Status='NS'

 And Sales_CloseDate>='03/01/2017' And Sales_CloseDate<='04/05/2017'



Order by Sales_Store, Sales_SalesPerson, Sales_CtrNo, Sales_CloseDate, Sales_RcptNo