FORMULA IN FOOTER

  • Thread starter Thread starter TOM
  • Start date Start date
T

TOM

I AM USING A TEXT BOX IN THE FOOTER AND I WANT A TOTAL
NUMBER FOR A SPECIFIC COLUMN. I ENTER MY FORMULA AS
FOLLOWS IN THE CONTROL SOURCE =Sum([Quantity]) WHEN I DO
THIS I GET AN ERROR. CAN SOMEONE HELP ME OUT ON THIS. I
NEED TO GET A TOTAL ON THE BOOTOM OF MY REPORT. I WOULD
APPRECIATE ANY HELP YOU MAY BE ABLE TO OFFER.

THANK YOU,
 
What you are doing should work if:
a) the text box is in the Report Footer section, not the Page Footer, and
b) Quantity is a field in the RecordSource of the report.

BTW, you might see if your keyboard has a CapsLock key so people don't thing
you are shouting.
 
I am going to expand on Allen's post and say that if you are
doing this in the page footer then move the control from
there and set the visibilty property to false. Create a new
control in the page footer and set the source to = the first
control

Mike
- learned this yesterday from Dev Ashish's site on
www.mvps.org

Allen Browne wrote:
: What you are doing should work if:
: a) the text box is in the Report Footer section, not the
: Page Footer, and b) Quantity is a field in the
: RecordSource of the report.
:
: BTW, you might see if your keyboard has a CapsLock key so
: people don't thing you are shouting.
:
:
: "(e-mail address removed)"
: <[email protected]>
: wrote in message
: :: I AM USING A TEXT BOX IN THE FOOTER AND I WANT A TOTAL
:: NUMBER FOR A SPECIFIC COLUMN. I ENTER MY FORMULA AS
:: FOLLOWS IN THE CONTROL SOURCE =Sum([Quantity]) WHEN I DO
:: THIS I GET AN ERROR. CAN SOMEONE HELP ME OUT ON THIS. I
:: NEED TO GET A TOTAL ON THE BOOTOM OF MY REPORT. I WOULD
:: APPRECIATE ANY HELP YOU MAY BE ABLE TO OFFER.
::
:: THANK YOU,
 
Back
Top