Problem with column totals on a form

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
Clive BeatonAccess DeveloperAsked:
Who is Participating?
 
Helen FeddemaConnect With a Mentor Commented:
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
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
 
Clive BeatonAccess DeveloperAuthor Commented:
Control Name          Control Source
SumOfDebits            =Sum([Debit])
SumOfCredits           =Sum([Credit])
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
 
Clive BeatonAccess DeveloperAuthor Commented:
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
 
Gustav BrockConnect With a Mentor CIOCommented:
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
 
Clive BeatonAccess DeveloperAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.