labels and calculations in one

[tweety]

i have a label that show a calculation in it "=Sum([txtSubTotal])"

i would like to display some text in front of the total amount, how can i do this

[Bob Fitz]

Something like:
= "My text " & Sum([txtSubTotal])

[tweety]

i tried as mentioned in the above post and i get the message shown in the screen shot below

[Bob Fitz]

Try:
= "£" & [txtTotal&Text] & [txtSelectedDate]
BTY: Using "&" in the name of a control is likely to cause you problems.