Appending to a calculated field's data

[grenee]

Good Night, I would like to append a text item to each value in a calculated field. consider the field name is "Division" and I want to append the word "Division" to the values put out by the field "Division"


My attempt was: Division & " " & "Division". This produced an error in the report.

Can anyone explain how this is done?

Thank you

 

[Galaxiom]

Use the Format property of the control where the Division value is displayed.
Assuming Division is a Number:

#" Division"

 

[grenee]

Thanks.

I entered the following: Division & " " & #"Division"

I got the following message: the expression you entered has an invalid date value.

Division is not a number value it is a string.

The results I am expecting is by example as follows: Science Division

 

[CazB]

In the control on the report, try using

=Division & " " & "Division"

or

=Division & " Division"

but make sure the controlname on the report isn't Division or it won't work! Just rename the control to something else, eg txtDivision

 

[grenee]

Thanks. Every thing works fine.