Discussions

Expand all | Collapse all

Need help with one of the function

  • 1.  Need help with one of the function

    Posted 07-14-2017 19:06
    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?


  • 2.  RE: Need help with one of the function

    Posted 07-14-2017 19:21
    [State A] & " - " & [State B]


  • 3.  RE: Need help with one of the function

    Posted 07-14-2017 19:30
    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.


  • 4.  RE: Need help with one of the function

    Posted 07-14-2017 19:35
    Correct and those choices i didnt look up on the master table, so i was little confused how will get state out of address.


  • 5.  RE: Need help with one of the function

    Posted 07-14-2017 19:40
    Those address components are also shown on the [Address field] itself when you are in Field Properties.


  • 6.  RE: Need help with one of the function

    Posted 07-14-2017 19:33
    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.


  • 7.  RE: Need help with one of the function

    Posted 07-14-2017 20:01
    Oh right sorry I forgot to mention that whenever you natively add an address field, QB creates all the different parts as separate fields. Glad you got it working!