Solved

Microsoft Access help with Sum

Posted on 2013-10-28
10
327 Views
Last Modified: 2013-11-01
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
Comment
Question by:jrsitman
  • 4
  • 4
  • 2
10 Comments
 
LVL 15

Expert Comment

by:Ess Kay
ID: 39606733
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
 

Author Comment

by:jrsitman
ID: 39606771
I read the article and it applies to a Report.  This is a form.  There is no Running Sum.
0
 
LVL 15

Expert Comment

by:Ess Kay
ID: 39606877
ah.. then just do =MedicationsCost
0
 

Author Comment

by:jrsitman
ID: 39606918
didn't work.  Only gave me the amount in then first field.  See attached.
medical3.png
0
 
LVL 15

Expert Comment

by:Ess Kay
ID: 39606939
is that a subform?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 15

Assisted Solution

by:Ess Kay
Ess Kay earned 200 total points
ID: 39606945
0
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 200 total points
ID: 39607014
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
 

Author Comment

by:jrsitman
ID: 39607068
Yep, that's where it is.  see attached.  I haven't read the article yet in the previous post.
medical4.png
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 39607223
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
 

Author Closing Comment

by:jrsitman
ID: 39617978
Thanks for the help
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now