Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

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
0
J.R. Sitman
Asked:
J.R. Sitman
  • 4
  • 4
  • 2
2 Solutions
 
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. SitmanAuthor Commented:
I read the article and it applies to a Report.  This is a form.  There is no Running Sum.
0
 
Ess KayEntrapenuerCommented:
ah.. then just do =MedicationsCost
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
J.R. SitmanAuthor 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
 
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
 
J.R. SitmanAuthor 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. SitmanAuthor Commented:
Thanks for the help
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now