How to insert data in a text field at the beginning?

[AtLarge]

Hello, I created an update query to a text field in a table. However, it inserts the data at the end of the string and I need to insert it at the beginning of the string that already exists. How do I move it to the front instead of the end?

This works but puts it at the end:

[Field Name] & "BlahBlah"

 

[MarkK]

If you just had to guess the answer, what would you guess?

 

[AtLarge]

If you just had to guess the answer, what would you guess?

lol. I've been guessing and searching. :banghead:

Take out the ampersand altogether? I tried moving it to the right side but no joy.

 

[MarkK]

Try . . .

"BlahBlah" & [Field Name]

 

[AtLarge]

Try . . .

"BlahBlah" & [Field Name]

DOH! Thanks Dude.