Add Text after value

[krzysiekk]

Hi

I got report with value

Summary: 1550

I want put : "1550 Kg"
Normally when I design Query I tray Summary: [table1].[value] &'Kg' - but now I can't because I using in query sum function.

Is possible to put "Kg" in report?

 

[boblarson]

Go to design view of your report and in the control source of your text box put

=[YourSummaryFieldItWasBoundTo] & " Kg"

 

[krzysiekk]

Not working showing #Error

 

[boblarson]

Make sure your field name and your control name are not named the same (which is what the default is when Access creates a report). You want to make sure to change the control name to something maybe prefixed with a txtSomeName and then you still will refer to the FIELD in the formula I gave you. Watch out, because if you have AutoCorrect still enabled (I would disable that if it is enabled because that can cause other problems) it will rename this code so you will have to go back and remove the txt from it.

 

[krzysiekk]

Thanks very much - working

 

[boblarson]

Cool, glad to hear.