Search results

Would u code the VBA as a Module? I have gotten the easy part to work with a query using the Like, but how do u refer to a table and search a column of its data in VBA?

Thing is, it will get more complicated because I want to give an accuracy level depending on how good the match is. Like if the street name is matched give it a 1, if only the county is matched it would be given a 4. (So areas given a '1' therefore have accurate grid references down to the...

There are 4 Address fields because it goes something like: Address1 - Street Name Address 2 - District Address 3 - City Addess 4 - County How do u refer to a table and search a column its data in VBA?

Hi all, I'm not sure if this should just be done in a query, or VBA. I have a table called Address and a table called Incidents. I want to search through the fields Address 1, 2, 3, and 4 in the Incidents table to see if they match the fields Address 1 in the Address table. Each address in...