I created a survey123 App to replace an older system in which paper forms were brought into the field and then later entered into a Microsoft Access Database. The old Access database had numerous queries and reports that were automatically generated to meet our state and federal permit reporting requirements, and now I need to create the same reports from the survey123 data. Can this be done within the program? From what I can tell you can generate reports but they are for each individual survey. I need to report all of the data at the end of each year such that each survey is its own row in a table. Do I need to do import the data into ArcMap to do this? I'm guess there are plenty of ways to do this. I'm curious what some of you all do. My supervisor wants me to import the data into Access and then generate the reports but I prefer to keep workflows as streamlined as possible.
Thanks for your advice.