Problem to create grand total

[Saddy]

i have a different multiple total in my report.when i make group total it
show only values
not the name of the field, but as soon as i make grand total it works well on
single total but not more than one, otherwise it starts to show the name of
the field.
i m given the example below so it can easy to understand
in first case while i m making group total ,suppose there are three values
salary,gratuity,Allowance
i calculate it in group footer
=sum([salary]) =sum([gratuity]) =sum([Allowance])
it returns
6788 88909 49890

while making grand total i did same in report footer but it prints textbox
name also
with the values
=sum([salary]) =sum([gratuity]) =sum([Allowance])
it returns
textbox1 2343 textbox2 43456 textbox3 23525

Is there Anybody to help me out
I will be very Thankfull
Thanks in advance
Saddy

 

[Guest]

Perhaps you need to delete the labels attached to the text boxes.a

Duane Hookom
Microsoft Access MVP

 

[Saddy via AccessMonster.com]

MY dear,
I have already deleted the text boxes but surprisingly even
it is showing the labels,actually problem is that even u delete the labels
then it print the name of the textbox, but there is no method to unname the
textbox.
keep in mind problems occur when you take
"multiple" grand total in your report
it is not only then show the name of the labels before the grand total it
also starts to show the name of group total also.
Thanks for Cooperation
take Care
Saddy

 

[Guest]

If your report is displaying something in a section that you don't want, you
need to select and then delete a control. You can select any control and then
press the tab key until you have selected the control you want to delete.

 

[Saddy via AccessMonster.com]

Dear Duane Hookom,
I have done what you are saying, in my report there is no label exist,
but still it is showing label ,
from where it is printing i don't know.
Plz give me your email address so i can give u my project
I badly need the solution
Thank you again for Cooperation
Saddy

 

[Guest]

You should post your email in a format that can't be extracted from the
posting such as saddyAThotmailDOTcom. Then I can contact you off-line.

 

[Saddy via AccessMonster.com]

Dear Duane Hookom,
Thanks for Cooperation, My email address is
(e-mail address removed).
actually i want to show you my project that is why i wanted your email
address,anyway I m looking forward for the best of my solution.
Take Care
Saddy

 

[Guest]

The problem actually involved exporting a report to Excel. Apparently control
names were appearing in Excel, not in the Access report.

I don't use this solution because of the seemingly random location of text
boxes, names, totals, etc... If anyone has a solution, feel free to chime in.