Concatenate string with field?

[cabbey77]

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]

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