I had yellow jackets behind the molding around my front door. After unsuccessful tries with several products to get rid of them I stumbled onto Sevin dust. I sprinkled it around the opening and some inside. The entire nest was dead in a day.
Wasp sprays that foam are really good but you have to use them at dusk, when all the resident bugs are tucking themselves in for the night. The foam stops (almost all) from getting out. If you spray during the day when most of the colony is off foraging, the wasp can smell or sense it, spread the word and off they go to make a new nest.
Sevin dust works good, too, but you have to get pretty close, don’t you?