We are developing a property look up tool for environmental hazards/chemical spills. In layout view we have a circular data extent with a graphic of a target house in the center and some proportional circles at increments of .125, .25, .5 and 1 miles from the center of the fixed extent. My environmental hazards/chemical spills are a point layer with 4 different categories, each respectively with requirements to query around the target house at 1/8, 1/4, 1/2, and 1 mile distances to see which, if any, of these points falls within its designated distance from the target house.
When exporting data from this layer that is within the view extent... is it possible to have a dynamic attribute table column that would change for each different target house address to tell me how far away the points are from this target house? i.e. whether they fall within those .125, .25, .5 and 1 miles for each category? In short is there a way to query distances (and even directions) from an address and have that data dynamically generated inside an attribute table column that could then be exported?