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.