1 Reply Latest reply on Aug 12, 2013 3:52 PM by philmodjunk

    how to use ! to match multiple fields

    JK415

      Title

      how to use ! to match multiple fields

      Post

           I am sorting through a database in which addresses have been broken down to street number and street name, how can I write a script that will find all the matches for both fields (so that the results will show all instances of both a matching street number and matching street name)?

        • 1. Re: how to use ! to match multiple fields
          philmodjunk

               Add a calculation field to your table that combines the values such as StreetNumber & " " & StreetName. Use the ! operator in that calculation field to find all records with a duplicate street address.

               Another method would be to set up a self join relationship with both street name and street number fields used as match fields.