Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Problem with column totals on a form

Posted on 2016-09-04
7
Medium Priority
?
42 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 52

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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

650 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