Hi all,
So--new problem-- I have 41 Tables that look something like this:
APN OWNER ACRES Site.ADDRESS Mail.ADDRESS
10220 Freddie 4 124 Right Rd. 124 Right Rd.
13445 USA 10 Washington DC Washington DC
15687 IRS 23 Washington DC Washington DC
13455 Tammy 12 ABC avenue ABC avenue
...with anywhere from 70,000-1 million records....
Basically, I want to summarize this information by creating an "OWNERSHIP CLASS" field which summarizes the information in the "OWNER" fields.
Ideally, I would like to fit all my data into 5 key classes:
GOVERNMENT
FOREST INDUSTRY
NON-INDUSTRY/BUSINESSES
FAMILY>10acres
FAMILY<10acres
So, if accomplished, my above sample table should look something like this:
APN OWNER ACRES ADDRESS OWNER CLASS
10220 Freddie 4 124 Right Rd. FAMILY<10acres
13445 USA 10 Washington DC GOVERNMENT
15687 IRS 23 Washington DC GOVERNMENT
13455 Tammy 12 ABC avenue FAMILY>10acres
I can't seem to find a clear cut way of doing this using the Append Query....and since I have 41 tables (with 70,000-mil records) I need to find a pretty good system of doing this.
Any thoughts???