Remove Text from a field based on a table

[aromano789]

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

 

[Mile-O]

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

 

[aromano789]

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

Tony