Tom, You need to GROUP BY rushnum, because it is not part of any of the five aggregate functions SUM, COUNT, AVG, MIN, or MAX.
Bill On Sat, 14 Feb 2004 21:01:55 -0500, Thomas J. Eldred wrote: >processdate,checknum,contirbdate,contamount,rushnum,contransid
