:-D sorry.. i was looking for a different name... think it is time for some coffee and chocolate! The view is present and exactly how I had wanted it to be.
Very much appreciate your assistance on this. Tom > Thank you Bill, > > The file now runs at the R:prompt--without an error. If I may further > ask, should I assume that this is a temporary view set up ...since > this new view did not appear in database explorer? > > > > > 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 > > > > > >
