I am looking to simplify a process that I use daily. I create csv files daily that have multiple query results inside of them.
What I do now is run the first query and export it into a csv file. Then I run the second query and store that into a seperate file. I then cut and paste the contents of the second file into the first. I would use a union query to get them into one statement, but they do not have the same number/type of fields.
Does anyone know if there is an easier way to get both search results in the same file? Thanks in advance for any help!