Label Question

[Guest]

I have built a report that outputs a list of invoices by group. I have
created a text box that outputs the sum of the invoices.

For the label of this text box I would like to specify the group then add
text. e.g.

I've tried this and I when run the report I get what I wrote:
=[Group_ID] & " " & "Invoice Total Amt"

Any idea what I'm doing wrong here? I would like the result to be Equipment
Invoice Total Amt.

 

[DebbieG]

Try changing it to a Text Box.

HTH,
Debbie

|I have built a report that outputs a list of invoices by group. I have
| created a text box that outputs the sum of the invoices.
|
| For the label of this text box I would like to specify the group then add
| text. e.g.
|
| I've tried this and I when run the report I get what I wrote:
| =[Group_ID] & " " & "Invoice Total Amt"
|
| Any idea what I'm doing wrong here? I would like the result to be Equipment
| Invoice Total Amt.