I am trying to print out my clients address on a single line, but the problem is that if any of my fields contain a null the formula is left blank. Also my numeric values converted to string have a comma in them (9,201 instead of 9201).
My data consists of 5 fields as such;
1 Apartment Number (Numeric) - 101
2 Apartment Number (String) - B
3 Building Number (Numeric) - 9201
4 Street Name (String) - Ocean
5 Street Indicator (String) - Ave
I would like to see;
101 - B - 9201 Ocean Ave or
9201 Ocean Ave (if fields are null).
My current formula is as such
Totext ({1},0)+" - "+{2}+" - "+Totext({3},0}+" "+{4}+" "+{5}
Does anyone have a way to fix the null values and my comma problem
My data consists of 5 fields as such;
1 Apartment Number (Numeric) - 101
2 Apartment Number (String) - B
3 Building Number (Numeric) - 9201
4 Street Name (String) - Ocean
5 Street Indicator (String) - Ave
I would like to see;
101 - B - 9201 Ocean Ave or
9201 Ocean Ave (if fields are null).
My current formula is as such
Totext ({1},0)+" - "+{2}+" - "+Totext({3},0}+" "+{4}+" "+{5}
Does anyone have a way to fix the null values and my comma problem