Hi there,
I have a database with 90,000 property records and I need to split the database into 5 geographic areas.
Those areas are defined by postcode districts, and a number of postcode districts make up an area. I have a column for postcode district and another column for area which is populated.
The geographic area is comprised of all the properties in that area, which are already defined by the area column, but is also comprised of a subset of the properties that border that area. These properties are part of another area according to the area column, but their postcode district is on the border of the other area.
I need to design a SQL View select query that I can run to identify these five geographic areas, which will then allow me to export 5 separate spreadsheets.
because of the overlap there will obviously be a number of duplicates across the 5 geographic areas.
My question is really how to go about this. I can either:
1) Define which postcode districts are part of the area overlap in the query. I.E. select certain postcode districts (up to about 20 possible) for the overlap and select the area.
2) Create new columns called overlap area 1, overlap area 2 etc, and populate those with a query and then select the overlap area column and the area column to produce a list for the geographic area.
As I'm also an Access newbie could you please tell me what code I would need for the Select Query.
Many thanks in anticipation of any help!