<< create temporary view tOrdShiptots (col names w/ commas) as select Control#, Model#, Outshipinv, SortOne, Quantity, SUM(ShipQty) from OrderShip + where clause w. group by clause. The error I get on this view is -ERROR- Illegal column specification (2512) >>
Your group by clause must contain all of Control#, Model#, Outshipinv, SortOne, Quantity and probably doesn't. -- Larry
