>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.