By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

SUM in form footer !

P: n/a
I have a continuous form with 2 fields OPBAL and INIT_BAL as the
control source.

In the form footer, for their totals I have 2 text boxes having
=Sum([OPBAL]) and =Sum([Init_Bal]) as their control source.

This works fine !
If however, on the form I change the name of the fields to Txt_OPBAL
and Txt_Init_Bal
the sum in the footer which I now change to Sum([Txt_OPBAL]) and
Sum([Txt_Init_Bal]) shows an ERROR#.
Is it imperative that to get a total in the form footer both, the
Control Source and NAME should be the same ?

Rgds,
Prakash.

Aug 6 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can sum a field in the form's RecordSource.
You cannot sum a control.

Therefore your expression needs to refer to the field name (typically what
you put in the control's Control Source), not the control name.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<pr*************@gmail.comwrote in message
news:11*********************@o61g2000hsh.googlegro ups.com...
>I have a continuous form with 2 fields OPBAL and INIT_BAL as the
control source.

In the form footer, for their totals I have 2 text boxes having
=Sum([OPBAL]) and =Sum([Init_Bal]) as their control source.

This works fine !
If however, on the form I change the name of the fields to Txt_OPBAL
and Txt_Init_Bal
the sum in the footer which I now change to Sum([Txt_OPBAL]) and
Sum([Txt_Init_Bal]) shows an ERROR#.
Is it imperative that to get a total in the form footer both, the
Control Source and NAME should be the same ?

Rgds,
Prakash.
Aug 6 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.