Skip to main content
Question

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 Address)

How do i create a formula to concatenate state-state from both the fields

Any thoughts?
    This topic has been closed for replies.

    [State A] & " - " & [State B]
    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.
    Hey Chuck that was easy, actually i was pulling complete address when i was trying to create join with another table, i was thinking i need to extract(state) from address and then need to concatenate :)

    Anyways i figured that out
    and Thanks for your help.
    Terms & ConditionsAccessibility statement