i have to remove textbox name

[Guest]

i m making a report which have both multiple group total and grand total,
for that i made textboxes in the group footer for group total and set the
value sum,
uptil now it is only showing values(sum of field) not the name of textbox,
but when i make textbox in report footer to make grand total and set the
value of textbox to sum it starts to show the name of textbox also, i just
want the value only
example
i made three textboxes and named it txt1,txt2,txt3
Total sum(salary) sum(total) Sum(Gratuity)
it is showing like that
Total txt1 sum(salary) txt2 sum(total) txt 3 sum(gratuity)

what can i do to remove the name of the text box and to print the value only
thanking you in advance

 

[Al Campagna]

Jimm,
What are the ControlSources of those unbound text controls?

I can only guess that you've concatenated the field names into the calculation...
like...
= "Salary " & Sum(Salary)
which would display as...
Salary 6865.23
Try just...
= Sum(Salary)
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Marshall Barton]

i m making a report which have both multiple group total and grand total,
for that i made textboxes in the group footer for group total and set the
value sum,
uptil now it is only showing values(sum of field) not the name of textbox,
but when i make textbox in report footer to make grand total and set the
value of textbox to sum it starts to show the name of textbox also, i just
want the value only
example
i made three textboxes and named it txt1,txt2,txt3
Total sum(salary) sum(total) Sum(Gratuity)
it is showing like that
Total txt1 sum(salary) txt2 sum(total) txt 3 sum(gratuity)

what can i do to remove the name of the text box and to print the value only
thanking you in advance

Double check that those names are not in label controls
attached to the text boxes. If they are, just delete the
label controls.

 

[Al Campagna]

Brilliant suggestion!
I would never have thought of it, and to be honest, when I responded, I didn't think the
OP had actually done a concatenation... but it was all I could think of.
I know exactly what you mean when the associated label generates just behind the Text
Control...
I bet a nickel that your suggestion is a "palpable hit"... Touché!
Al Camp