Need help with one of the function
I have 2 address fields in a table "Source Address" , "Destination Address" and i want to create a text-formula field which actually takes concatenates State(Source Address) - State (Destination Addre...
Forum Discussion
You can in fact use the Address components in a formula, even though they are not listed in the field list. When you are building your formula they will be offered up as choices.
Those address components are also shown on the [Address field] itself when you are in Field Properties.