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?
="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?