I currently have 3 spreadsheets with simliar information. How can I take a database and export only select fields to make either a report or table?
Here is the example with types of info i will be using:
100 communities and all their roads. Each of these communities are in a borough, which is then in a region.
Then we have a mileage for each road.
Where I have difficulty is that we have another set of data that would be awesome if we could just include into this which is all of those roads but additionally they have:
Classification
Surface type/condition
Traffic count
Some roads have two classifications.. each of those having a mileage.
Does anyone have any pointers for where I could go with this? I would really like to see all of this data in a database that spits out the needed tables and totals.
Lastly I should ask if anyone knows anything about ArcGIS data being compatible with Access.. Most of this information will be in a geodatabase.
Thank you for ANY and all help.
Cheers
Here is the example with types of info i will be using:
100 communities and all their roads. Each of these communities are in a borough, which is then in a region.
Then we have a mileage for each road.
Where I have difficulty is that we have another set of data that would be awesome if we could just include into this which is all of those roads but additionally they have:
Classification
Surface type/condition
Traffic count
Some roads have two classifications.. each of those having a mileage.
Does anyone have any pointers for where I could go with this? I would really like to see all of this data in a database that spits out the needed tables and totals.
Lastly I should ask if anyone knows anything about ArcGIS data being compatible with Access.. Most of this information will be in a geodatabase.
Thank you for ANY and all help.
Cheers
