I have 2 tables.

Table 1 is called StreetSuffix. Only one field Exist in it.
(Street,Ave,Road,Terrace,Place)

Table 2 has the street name (Boston Post Road, Walnut Street)

Is there a way i can compare the street name in table 2 with all the street suffix in table 1 and remove the suffix text if it exist.

I need to learn VBA

Thanks Tony

Why have suffixes in one table if the full street name is included in the other table?

looking to have the suffix removed from the street name based on what data is in the suffix table.

Tony