ADP Form totals causing error

[scott]

Is there a difference between access and ADP forms in the way you total
values in the "Form Footer" section?

In my sub form footer, I'm trying to use SUM function to total up a control
on the sub form. I've done this many times
without any trouble in a regular Access file. I'm getting the #Error in the
total control in the subform footer.

For a test, I used the formula in FORMULA 2 below and the ADP subform
returns the 1st
value on the subform and then divides by 2. But, if I try FORMULA 1, I get
the #Error.

This doesn't have anything to do with field data types because
COUNT([myIDfield]) also returns the #Error and myIDfield is an integer type.

Any ideas on what I could be doing wrong?


FORMULA 1 (gives #Error):

=SUM([decDuration])


FORMULA 2 (works and just displays value of 1st value in subform divided by
2):
=([decDuration]*2)

 

[Sylvain Lafontaine]

Maybe http://support.microsoft.com/?id=225992 ?

 

[scott]

thanks.

Maybe http://support.microsoft.com/?id=225992 ?

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Is there a difference between access and ADP forms in the way you total
values in the "Form Footer" section?

In my sub form footer, I'm trying to use SUM function to total up a
control on the sub form. I've done this many times
without any trouble in a regular Access file. I'm getting the #Error in
the total control in the subform footer.

For a test, I used the formula in FORMULA 2 below and the ADP subform
returns the 1st
value on the subform and then divides by 2. But, if I try FORMULA 1, I
get
the #Error.

This doesn't have anything to do with field data types because
COUNT([myIDfield]) also returns the #Error and myIDfield is an integer
type.

Any ideas on what I could be doing wrong?


FORMULA 1 (gives #Error):

=SUM([decDuration])


FORMULA 2 (works and just displays value of 1st value in subform divided
by
2):
=([decDuration]*2)