>I have created a view that I would like to have be just a summary table. How do I get my numeric field to be a summary of all the records that I have grouped? Thanks in advance!
Select SUM(myfield) As mysumfield From mytable Group by fieldX
BTW, there is no necessity to use view for summarization, you may better use plain cursor.
Edward Pikman
Independent Consultant