Adding suffix to all the values in a field ( concatenate)

[mls via AccessMonster.com]

I want to add a suffix to all the values in one field.. and I tried the
follwing but show errors

temp = RNP
temp = Trim(Left(temp) & "_" & "Ct")
MsgBox temp


my output should show at RNP_Ct

 

[Dorian]

temp = temp & "Ct"
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[mls via AccessMonster.com]

I tried this but my test value is just _Ct. RNP is missing
test = temp & "_Ct"
MsgBox test

temp = temp & "Ct"
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

I want to add a suffix to all the values in one field.. and I tried the
follwing but show errors

[quoted text clipped - 4 lines]

my output should show at RNP_Ct

 

[Gina Whipp]

MLS,

Not sure where the rest of the code is but try...

Dim test As String
Dim temp As String

temp = "RNP"
test = temp & "_Ct"

MsgBox = test

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Dorian]

Well you do have to dimension temp and move the prefix into it.
I had assumed you'd know that.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

I tried this but my test value is just _Ct. RNP is missing
test = temp & "_Ct"
MsgBox test

temp = temp & "Ct"
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

I want to add a suffix to all the values in one field.. and I tried the
follwing but show errors

[quoted text clipped - 4 lines]

my output should show at RNP_Ct

--



.