?
Solved

Problem with column totals on a form

Posted on 2016-09-04
7
Medium Priority
?
41 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 22
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 22
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

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 51

Assisted Solution

by:Gustav Brock
Gustav Brock earned 600 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 1400 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

770 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