Calculating sums by type

[CT_AccessHelp]

I have a form that I would like to have a running sum by the type of data entered (Fund_Type). Is there an easy way to do this. I would like it to store in the value Running_Sum field.



Yall are the best - Thanks soooo much for the help!

[June7]

This is not easy to do in forms. Forms were not intended for this sort of data manipulation. Bing: access running sum in form

http://support.microsoft.com/kb/290136

http://www.tek-tips.com/faqs.cfm?fid=5248

http://support.microsoft.com/kb/210338

Textbox in report has a RunningSum property. Also, records in reports can be grouped and running sums calculated within each group.

[CT_AccessHelp]

I was going to put a subform on the form to dispay a query that queries and sums by fund_type but it will not let me keep the the continuous form view when I add the subform and I need to keep the form continuous.

[June7]

Then you might find this of interest http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[CT_AccessHelp]

I was able to make the form I was working with continuous by making both forms subforms under one form. Now I am trying to figure out how to make the query subform update when an entry is made.

[CT_AccessHelp]

Ok - Update - I found a code the works and the query is updating when i add or update a record on the State_Allots_subform however, the query does not update when I delete a record on State_Allots_subform - Any Ideas?

[June7]

You are deleting with the keyboard DELETE?

Try code in the After Del Confirm event to requery the form.

[CT_AccessHelp]

AWESOME - It Worked! Thank you!