Error on simple expression in footer

[espee2]

(Access 2002) I'm trying to add a simple "Grant Total" to my
invoice.:
(in a TextBox, Control Source)... =Sum([SalePrice]+[ShippingPrice])

I'm following 'Help' and the 'Northwind sample Database' example to
the tee. I get #ERROR displayed in the field if I put the textbox in
the PageFooter where Help says I can put it, where it belongs. It
works fine in the Detail section but looks horrible because it
repeats with each record. I tried adding a group footer between the
Detail and PageFooter and put the code in there but it just repeats
with each record too.

 

[John W. Vinson]

(Access 2002) I'm trying to add a simple "Grant Total" to my
invoice.:
(in a TextBox, Control Source)... =Sum([SalePrice]+[ShippingPrice])

I'm following 'Help' and the 'Northwind sample Database' example to
the tee. I get #ERROR displayed in the field if I put the textbox in
the PageFooter where Help says I can put it, where it belongs. It
works fine in the Detail section but looks horrible because it
repeats with each record. I tried adding a group footer between the
Detail and PageFooter and put the code in there but it just repeats
with each record too.

It needs to be in the *REPORT* footer - not the Page footer.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[railcrew]

(Access 2002) I'm trying to add a simple "Grant Total" to my
invoice.:
(in a TextBox, Control Source)... =Sum([SalePrice]+[ShippingPrice])

I'm following 'Help' and the 'Northwind sample Database' example to
the tee. I get #ERROR displayed in the field if I put the textbox in
the PageFooter where Help says I can put it, where it belongs. It
works fine in the Detail section but looks horrible because it
repeats   with each record. I tried adding a group footer between the
Detail and PageFooter and put the code in there but it just repeats
with each record too.

It needs to be in the *REPORT* footer - not the Page footer.
--

             John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:http://social.msdn.microsoft.com/Fo...al.answers.microsoft.com/Forums/en-US/addbuz/
and see alsohttp://www.utteraccess.com

I got it to work, thanks