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
Medium Priority
42 Views
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.

Capture.JPG
0
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

LVL 22

Expert Comment

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

ID: 41784162
Control Name          Control Source
SumOfDebits            =Sum([Debit])
SumOfCredits           =Sum([Credit])
0

LVL 22

Expert Comment

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

Author Comment

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.

0

LVL 52

Assisted Solution

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

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:

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

Author Comment

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

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…
###### Suggested Courses
Course of the Month12 days, 6 hours left to enroll

#### 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.