Adrian, thanks for email, I am venting, but It seems like I have to store all my data online, have a tech make an entry say 1gallon of a mixed herbicide, which contains 4 different reportable pesticides, export that via csv or excel / update my tables/ Then use Access to generate a report that breaks down all 4 different chemicals into a report that the County Ag Commissioner needs/demands – on their exact form. ArcMap-ArcGIS do not allow the data manipulations that I perform. OH, I agree that non experienced users should have no problem flipping back and forth, But I have only been using arcmap for 10-12 years or so. And its silly not to be able to display a basic table that is in access which includes “name and x and y” without exporting to csv, then importing back. We have mosquito traps that we bring mosquitoes back to the District that we count, identifiy, do lab testing, and generate reports, I will have to now export these numbers into an excel, or csv file before they can be viewed on a map, I haven’t counted the number of time I have seen in some of your (ESRI’s) magazines and communities where a phrase goes something like “ this was achieved by using ArcGis and an Access database” Hey it’s the weekend, Enjoy Mark D Systems Administrator Delta Vector Control District
... View more
Thanks Mitch for the inquiry, the fields were Text only, one field was 4 char in length the other was 10 char in length, It was a mistake (on my part) to presume what I saw was what I got, the join – based on parcels, was a 1 to many. The 3 miscalculations were just referencing a second point within the parcel which happened to be sequentially higher.
... View more