Form Footer - 1 Sum OK - 2 = #Error!

  • Thread starter Thread starter Andy Jackson
  • Start date Start date
A

Andy Jackson

Ladies and Gents

I am using Access 2000.

I have a form in Tabular Format, which is filled by a query and has some
calculated fields.

I want to sum the fields at the bottom in the Form Footer.
The first Field "=sum([Column_1])" works fine, but as soon as I add another
field "=sum([Column_2]), both fields display "#Error". - Arggh!

Has any one seen this before?
Does anyone, please, know how to get round it?

Any suggestions gratefully received.
 
Ladies and Gents

I am using Access 2000.

I have a form in Tabular Format, which is filled by a query and has some
calculated fields.

I want to sum the fields at the bottom in the Form Footer.
The first Field "=sum([Column_1])" works fine, but as soon as I add another
field "=sum([Column_2]), both fields display "#Error". - Arggh!
Click to expand...

What are the Control Sources of Column_1 and Column_2? Note that you
cannot Sum controls that are calculated on the form - only fields that
exist in the Form's Recordsource query. If (frex) Column_2 is a
calculation, you may want to do the calculation in the Query upon
which the form is based, rather than directly in the form control's
Control Source.
 
Back
Top