We have program that exports data in an Access Database format. The program does not export exactly the way we want so I figured the best way to do this is to create a second ACCESS file called FINAL REPORT that taps into the original export data.
This way the user exports an Access database daily named “Access Report Data”, and runs the file you will create (FINAL REPORT) then the report should return the desired results each time. Unless you can think of a better way.
Keep in mind the data rendered may be conditional based on the vendor. The fields and tables are defined.
I have more ACCESS and SQL projects that need attention as well. If we work well together then I may send the work your way
About 12 fields, and it just needs to be listed in a spreadsheet format.