05-18-2010 02:35 PM
I'm trying to create a custom field in a report which will combine two phone number fields. I understand how this works with string fields like:
However I don't know how to concatenate two phone number fields
If Phone2 = NULL THEN
customPhone.Text = Phone1
customPhone.Text = Phone1&" or "&Phone2
Is the error a result of phone fields being integers? If so, how would I code this to run properly?
05-19-2010 08:03 AM