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.
- Correct and those choices i didnt look up on the master table, so i was little confused how will get state out of address.
- Those address components are also shown on the [Address field] itself when you are in Field Properties.
