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.


Reply via email to