Search results

Hey there! I'm struggling at the moment to make a piece of VBA that will allow me "bubble sort" and re-arrange the internal characters within a string E.g. String "BAA" will become "AAB" Below is my feeble attempt at the VBA code for this Public Function sortwdaz(txtstring1 As String)...

Hi All, My database has two tables: 1. Complete Address Data 2. Address conditions. Table 1. has verbose customer [address] data like 11 smith st, 14 Kent Rd etc. Table 2. has [std] address conditions, ST, RD, Street, Road etc. How can I query ALL records by field [address] in table 1 by...

Hey Guys, Just wondering how I would go about comparing two strings, and spitting the results out a similarity percentage? E.G. (String 1) Postal Address: "11 John St" (String 2) Street Address: "11 John Street" (Output): 80%? Cheers