Concatenate string with field?

cabbey77 · Jan 3, 2005

Here is my macro how I have it written:

Sub Job_Title()
If Field$("PS_JOB.DEPTID") = "0733118200" Then
D = "CMP"+Field$("PS_JOBCODE_TBL.DESCR")
Else
D = Field$("PS_JOBCODE_TBL.DESCR")
DERIVEDFIELD D
End If
End Sub

I get the proper string on all other Titles except the one where the Field is = to 0733..., where I get NA.

obiwaugh · Jan 5, 2005

Try this: (end the if statement before the derivedfield statement)

Sub Job_Title()
If Str$(Val(Field$("PS_JOB.DEPTID"))) = Str$(0733118200) Then
D = "CMP"+Str$(Val(Field$("PS_JOBCODE_TBL.DESCR")))
Else
D = Field$("PS_JOBCODE_TBL.DESCR")
End If

DERIVEDFIELD D

End Sub

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Concatenate string with field?

cabbey77

Technical User

obiwaugh

Instructor

Similar threads

Part and Inventory Search

Sponsor