Thanks Razzak. That seems to work quite well for my select. Bill >>> "A. Razzak Memon" <[email protected]> 7/24/2009 11:48 PM >>> Bill,
Here is part 2 ... SELECT Trial, PlotNum, (SUM(Stand1)) AS TotalStand1 FROM RawData + WHERE Trial = '098781' AND PlotNum < 1005 + GROUP BY Trial, PlotNum Very Best R:egards, Razzak.

