CALCULATION QUESTION

[penndro]

I am trying to show the total payments made in a summary box using the data shown in a SubForm. Can anyone help me with this issue.

I need to know the SUM of all Payments currently showing in my subform. Payments should be filtered to record currently displayed on the main form.

 

[gwoman]

Here is a quick & easy way I have used in the past.

Try creating a text box on your subform for caluclation purposes. Then ... in the record source 'query' of the subform ... create an alias for your payments field and do a sum on that column. Set the control source of the calculation text box to this newly created alias.

Then set the control source of the Summary text box on your main form to the calculation text box of your subform.

Hope this helps! Have a good one!

 

[PHV]

In the footer section of your continuous subform create a TextBox with ControlSource set to:
=Sum([name of payment field in subform's recordsource])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244