assuming that the tables are properly normalised then you should be able to do what you want be either
limiting the data returned by identifying the district you want as part of a WHERE clause
OR if you knwo you only ever want to use the data from a specific district then copy the entire dataabse, and using a series of delete queries delete the redundant data.
is there a quick and easy way of dong this?
..well if the data is normalised and has properly defined relationships AND where appropriate thoise realtionships are on a delete cascade then yes.
but I doubt it.
is there another easy way. not that Im aware of.
if you have limited exepreince in query design, then I would strongly suggest you sanitise your data, remove the redundant stuff so it doesn't cuase inadveertnat problems. BUT ONLY on a copy of the dtaa as you never know when you might want to run comparatives against other sidtgricts
can people here do it for you, no. not least because we dont know your table design
as to stuffign the data into Excel, well that is easy enough. either pull the data into EXCEL by runnign a query in Excel
or push the data from Access by saving it in excel or CSV format
I'd rather be riding on the Tiger 800 or the Norton