By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,668 Members | 1,503 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,668 IT Pros & Developers. It's quick & easy.

Question - SQL View - Select Query.

P: 6
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!
Jan 2 '08 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,487
Steve,
It would help to envisage this if you could post some example data here.
That way you could also indicate what the names of the relevant fields are for us. Any answer would be easier with that info.
Jan 2 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.