AnsweredAssumed Answered

Attribute Assistant

Question asked by jeffburton on Jun 27, 2018

Currently in my attribute assistant table I have the following statement to calculate an address.  This statement works fine.

SiteAddressPoint    FULLADDR    EXPRESSION    Trim([ADDRNUM]) & " " & Trim([FULLNAME]) & " " &Trim([UNITTYPE]) & " " & Trim([UNITID])

Some address records have building names.  If the field "BUILDING" is not null I would like to add its value to the end of the above calculation (" " & "BLDG" & " " & [BUILDING])

 

I can't seem to get the syntax correct.

#Attribute Assistant

 

Thanks,

Bob

Outcomes