Dynamic list by zip code

Hi everyone,

 

This isn’t exactly an Analytics question, but this seems like the group that might have an answer to a question that is stumping me!

 

I’d like to have a dynamic list of any patrons in our database who live within 50 miles of our theater. It would be really handy for multiple functions of our department to have this list automatically refresh on a daily basis. That’s approximately 210 zipcodes but I can only think of how to pull this list as an extraction (with each zipcode + wild card characters for the possible four digit extension as its own criteria), which wouldn’t allow me to make it dynamic.

 

Has anyone come up with a solution for how to do this? Thanks in advance for any insight you can share!