Rabu, 25 Maret 2015

[MS_AccessPros] Comparing two tables

 

I have a table of all registered voters (Voters) from the board of elections and a table of all contacts (Patrons). Not all Patrons live in the precinct and not all are registered to vote. I have added a field to the Patrons table to be populated by the VoterID from the Voters table.  


I want to populate that field in Patrons. 


I want to compare the tables with a progressively wider net. 


FirstName+MiddleName+LastName+HouseNumber+StreetName

FirstName+MiddleName+LastName (Show HouseNumber and StreetName)

LastName+HouseNumber+StreetName (show FirstName and MiddleName)


In my perfect world, it would ask me to pick the match that made sense, I click on it, and the VoterID field is populated in Patrons table.


Am I reaching too far here?


Thanks



__._,_.___

Posted by: jan.hertzsch@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar