Microsoft Access help with Sum

I'm trying to get all the Medications charges to display on the bottom of one of our forms.  See screen shots.  I've tried different formulas with no success.
medications.png
medications2.png
J.R. SitmanIT DirectorAsked:
Who is Participating?
 
Helen FeddemaCommented:
If you want a total of all the charges, you can do this in a form footer, or in a subform.  Try placing a textbox in the form footer, with the ControlSource of =Sum([MedicationsCost]).  A true running sum can only be done in a report, but I think you just want a total, so this method should work.
0
 
Ess KayEntrapenuerCommented:
you need to make a running sum, or a function which queries the database


running sum:   https://office.microsoft.com/en-us/access-help/calculate-a-running-sum-cumulative-total-HP005187388.aspx
0
 
J.R. SitmanIT DirectorAuthor Commented:
I read the article and it applies to a Report.  This is a form.  There is no Running Sum.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Ess KayEntrapenuerCommented:
ah.. then just do =MedicationsCost
0
 
J.R. SitmanIT DirectorAuthor Commented:
didn't work.  Only gave me the amount in then first field.  See attached.
medical3.png
0
 
Ess KayEntrapenuerCommented:
is that a subform?
0
 
Ess KayEntrapenuerCommented:
0
 
J.R. SitmanIT DirectorAuthor Commented:
Yep, that's where it is.  see attached.  I haven't read the article yet in the previous post.
medical4.png
0
 
Helen FeddemaCommented:
I don't see the MedicationsCost field on the form.  What do you get in the Sum field in the footer?  If this is a calculated field on the form, you may need to put the entire expression in the Sum() parentheses.
0
 
J.R. SitmanIT DirectorAuthor Commented:
Thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.