I ended up creating a separate Locations table with "Names" and "Addresses", which works well for repeated locations.
My details table has a related names field which will look up the address, resulting in functional name and address fields in my reports.
2 downsides: A) the initial use of an address still requires a google search (ie "Hilton Gardens Inn, Atlanta) to find the correct address. B) I haven't figured out how to use one-off addresses without adding them permanently (and dirtying) the locations list. I trust there's a solution for this latter issue.
