!!!HAPPY VALENTINE'S DAY!!! I am trying to create a view that aggregates values in a single table.
The table is RUSHTRANS having columns called processdate,checknum,contirbdate,contamount,rushnum,contransid What I am aiming for is a display of the date of the last contribution, the total contribution, the average, the max and min contributions. I have gotten the select to work at the R:Prompt, but when adding it to a create view and running it as a file, I get an error 2045... The code I am using is: CREATE VIEW rushcontview + (donornumber, donoravg, donormin + donormax, datelast) AS SELECT + (CTXT(rushnum))=10 , + COUNT(*) , + SUM(contamount ) , + AVG(contamount ) , + MIN(contamount ) , + MAX(contamount ) , + MAX(contirbdate ) + FROM rushtrans + ORDER BY rushtrans.rushnum RETURN What am I missing? or doing wrong.... I have been bouncing from error to error... Have gotten the select to perform at the r:prompt, but when running it as a view I get an error when trying it as above I get illegal Select Function with GROUP BY i get syntax is incorrect for Create with no GROUP or ORDER BY I get illegal Select Function and a whole other range of errors as I've tried to determine where I'm wrong ... Thank you for any suggestions tom
