urgent help calculated field label won't work

[tizwaz]

I have a calculated field to count the entries in a section. The field totals fine but I am trying to get the label to say total for [company] by doing the following but it won't work
="Total for" & [company] & "is"
but when I preview report it says ="Total for" [company] "is"
whereas I don't want the speach marks to show and I want the name of the comany. I am putting it in the footer for the company grouping - does anyone know what is going wrong?

 

[PaulBricker]

Use a textbox to hold the value. That should solve the problem.

Paul

 

[tizwaz]

Thanks Paul but it is in a text box - any other clues?

 

[PaulBricker]

I'm assuming you have two textboxes. One to count the number of entries and the other to hold the "Total for " & [Company] & "is ".
What exactly do you have in the Control Source for the textboxes.

Paul

 

[CosmoKramer]

I think Paul's on the right track. Are you sure you are not using a label control instead of a text box?? The way you describe the control is displaying seems to indicate that it's a label......

 

[tizwaz]

thanks guys but although I described it as a label it is a text box. The right hand box contains the calculation and the left hand one contains what I want to read as the text. Strangely enough in design view it keeps hiding the & - even if I widen the box - don't know if this is relevant.

 

[PaulBricker]

Double check the name [Company]. Although the Control may be bound to the Company Field in the Table/Query, it isn't always the name of the Control. Otherwise, this should work.

Paul