Solved

Problem with column totals on a form

Posted on 2016-09-04
7
36 Views
Last Modified: 2016-09-06
I have a form where I can't get any values in the SumOfDebits or Credits.  It works fine in the report of the screen.

Any clues?

Image attached.

Thanks in advance.
Capture.JPG
0
Comment
Question by:CRB1609
7 Comments
 
LVL 19
ID: 41784058
if SumOfCredits is the control name with the equation =Sum([credit) then realize you have to repeat the equation in another control

If you still need help, please tell us the control source and control name of each of your calculated controls
0
 

Author Comment

by:CRB1609
ID: 41784162
Control Name          Control Source
SumOfDebits            =Sum([Debit])
SumOfCredits           =Sum([Credit])
0
 
LVL 19
ID: 41784276
Are the equations in the form footer or form header?
What are the control names for the controls with Debit and Credit?
What are the data types of Debit and Credit?
Do the equations start with an = and not a space?
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:CRB1609
ID: 41784380
Thanks for your response.

The equations are in the subform footer.

The control names for the controls with Debit and Credit are Debit and Credit.

The data types of Debit and Credit are: Field size Double, Format Standard, Dec Pl 2.

The equations start with an =
0
 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 150 total points
ID: 41784500
The data types of Debit and Credit are: Field size Double

You should always use data type Currency for amounts and, indeed, when these get calculated.

/gustav
0
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 350 total points
ID: 41784833
I made a continuous form type form (that is what your subform appears to be), bound to a little table with a few rows of transactions, with a total in the form footer, and it works -- so possibly there is some issue with control or field names, or the form may be corrupted, and needs to be recreated.  Here is a screen shot of my sample form:

Transactions form
The control source of the total controls in the footer is:  =Sum([TransAmount])
0
 

Author Comment

by:CRB1609
ID: 41787095
Gustav: I think you are probably correct.

Helen: I recreated it in a different database and it worked, so I suspect some corruption.  I'll recreate the database.

Thanks to both of you.

Clive
0

Featured Post

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)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

920 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

12 Experts available now in Live!

Get 1:1 Help Now