asked on

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

crystal (strive4peace) - Microsoft MVP, Access

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

Clive Beaton

ASKER

Control Name Control Source
SumOfDebits =Sum([Debit])
SumOfCredits =Sum([Credit])

crystal (strive4peace) - Microsoft MVP, Access

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?

Clive Beaton

ASKER

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 =

SOLUTION

Gustav Brock

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Helen Feddema

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Clive Beaton

ASKER

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