Skip to main content
Question

Need help with one of the function

  • Jul 14, 2017 11:06 PM UTC
  • 0 replies
  • 49 views
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.

    • ChuckGrigsby
    • Qrew Cadet
    • Jul 14, 2017 11:21 PM UTC
    [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.
    • SnehaWankhede
    • Author
    • Qrew Corporal
    • Jul 14, 2017 11:33 PM UTC
    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