how to use ! to match multiple fields
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)?
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.